[Solved]: Track Changes Greyed Out in Excel (3 Quick Fixes)

Method 1 – Unprotect Workbook in Excel

The track changes option becomes greyed due to various reasons. One of the reasons is that your workbook is protected with a password.

Step 1:

• From the “Review” option select “Unprotect Sheet”.

• Enter the password to unprotect the worksheet.
• Press OK to continue.

• The “Track Changes” option will not be greyed out anymore.

Step 2:

• To check if the feature is working, click “Highlight Changes” from the “Track Changes” ribbon.

• A new dialog box will open named “Highlight Changes”.
• Check mark the “Track changes while editing. This also shares your workbook.”
• Press OK.

• If you change the value in one cell you will see the track changes feature will show the change in a comment box confirming the tracking of changes in the workbook.

Method 2 – Enable Share Workbook to Solve This Issue

Another reason why the track changes option becomes greyed due is if the workbook is not shared.

Steps:

• Click the “Share Workbook” option from the “Review” option.

• A new window named “Share Workbook” will open.
• Check the “Use the old shared workbooks feature instead of the new co-authoring experience”.
• Press OK.

• The workbook is shared and track changes feature will be enabled.

Method 3 –  Ungroup Worksheet to Activate Track Changes Option

When worksheets are grouped, the track changes option becomes greyed out.

Steps:

• In the following image, several worksheets are grouped.

• So the “Track Changes” option is greyed out.

• Right-Click the mouse while placing the cursor over any worksheet bar.

• A dialog box will appear. Choose “Ungroup Sheets”.

• The worksheets will be ungrouped solving the track changes greyed out issue in excel.

Download Practice Workbook

Related Articles

• How to Use Formula to Track Cell Changes in Excel
• How to Check Edit History in Excel Online
• How to See Who Made Changes in Excel

<< Go Back to Track Changes | Share Workbook | Workbook in Excel | Learn Excel