Why is my track changes greyed out in Excel?

Why is my track changes greyed out in Excel?

If the Track Changes button is unavailable (grayed out) in your Excel, most likely your workbook contains one or more tables or XML maps, which are not supported in shared workbooks. In that case, convert your tables to ranges and remove XML maps.

Why is tracked changes greyed out?

It will become grayed out when enabled. If you don’t see the status of track changes in your status bar at the bottom of Word, then you probably want to turn that feature on. Right click anywhere on the status bar and where it says Track changes make sure there is a checkmark beside it.

How do I turn on Track Changes in Excel 2007?

Turning on Track Changes in Excel

1. Open an Excel document and click on the Review tab.
2. Click the Track Changes button (located on the far right).
3. A small drop-down menu will now appear.
4. In the dialogue box that opens, check the box next to Track changes while editing.
5. You now have the following options:

How do I turn on Track Changes in Excel?

To turn on Track Changes:

1. From the Review tab, click the Track Changes command, then select Highlight Changes from the drop-down menu.
2. The Highlight Changes dialog box will appear.
3. If prompted, click OK to allow Excel to save your workbook.
4. Track Changes will be turned on.

Why are my track changes not showing different colors?

The Track Changes tab of the Options dialog box. Make sure that all the Color settings (with the exception of the color setting for the change bars) are set to “By Author.” If these settings are for a specific color, then it can affect how changes are displayed in the document.

Why is data tab grayed out in Excel?

When an Excel sheet is protected, various icons and features of the program will be disabled. With exception to few icons in the Data tab, most of them will be grayed out or not clickable. To ensure that your worksheet is not protected, click on Review tab > and see if an Unprotect Sheet icon is visible.

How do you track changes in conditional formatting in Excel?

Change a conditional formatting rule

1. Click in the range that contains the conditional formatting rule that you want to change.
2. On the Home tab, click Conditional Formatting.
3. Click Manage Rules.
4. Select the rule, and then click Edit Rule.
5. Make the changes that you want, click OK, and then click OK again.

How do I track changes in Excel?

Enabling the Track Changes in Excel Feature

1. Go to the Review tab.
2. In the Changes group, click on the Track Changes option and select Highlight Changes.
3. In the Highlight Changes dialog box, check the option – ‘Track changes while editing. This also shares your workbook’.
4. Click OK.