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

When you share a workbook that gets checked by various users at that time you need to check or review the changes. You can check and also review by enabling the track changes feature of Excel. While working in Microsoft Excel sometimes you will find the track changes option is greyed out. Today I am going to share with you how to fix track changes greyed out in Excel.

Reasons Behind Track Changes Option Gets Grayed Out in Excel

Track Changes option is one of the best features of excel where you can track and review your changes and other multiple user changes. But sometimes you will find the track changes option is greyed out. The main reasons behind it are-

  • While Editing a Cell
  • If Workbook is Protected
  • If Worksheets are Grouped Together

How to Solve Track Changes Greyed Out in Excel: 3 Easy Fixes

In the following article, I have shared 3 Simple methods to solve track changes greyed out in Excel.

Suppose we have a dataset of some Products and their Total Sales. As you can see from the following screenshot the “Track Changes” option is greyed out. Now, we are going to solve this greyed out problem by enabling the greyed out option in excel.

Track Changes Greyed Out in Excel

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. Just unprotect the workbook and enjoy the track changes feature. To do so-

Step 1:

  • First, from the “Review” option select “Unprotect Sheet”.

Unprotect Workbook in Excel

  • Second, type the password to unprotect the worksheet.
  • Hence, press OK to continue.

  • Finally, you will see the “Track Changes” option is no more greyed out.

Unprotect Workbook in Excel

Step 2:

  • In order to check if the feature is working or not let’s click the “Highlight Changes” from the “Track Changes” ribbon.

  • Therefore, a new dialog box will open named “Highlight Changes”.
  • Then, check mark the “Track changes while editing. This also shares your workbook.
  • Hit the OK button to continue.

Unprotect Workbook in Excel

  • Now, if we change the value from 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.

Track Changes Greyed Out in Excel

2. Enable Share Workbook to Solve This Issue

Track changes option becomes greyed if you have not shared your workbook on your system or a drive. To solve this follow the steps below-


  • Above all, click the “Share Workbook” option from the “Review” option.

Enable Share Workbook to Enable the Feature

  • Therefore, a new window will open named “Share Workbook”.
  • Hence, from the window check mark the “Use the old shared workbooks feature instead of the new co-authoring experience”.
  • Press OK to continue.

  • In summary, the workbook is shared and we have successfully enabled track changes feature in excel.

Enable Share Workbook to Enable the Feature

3. Ungroup Worksheet to Activate Track Changes Option

If you are working with various worksheets in a workbook then you might have grouped the worksheet for a working purpose. When the worksheets are grouped the track changes option becomes grey. Follow the instructions below to ungroup the worksheet and enjoy the track changes feature properly-


  • As you can see from the following screenshot several worksheets are grouped.

Ungroup Worksheet to Activate Track Changes Option

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

  • Besides to solve this click the right button of the mouse while placing the cursor over any worksheet bar.

Ungroup Worksheet to Activate Track Changes Option

  • Generally, a dialog box will appear. From there choose “Ungroup Sheets”.

  • Finally, the worksheets will be ungrouped solving the track changes greyed out option in excel.

Ungroup Worksheet to Activate Track Changes Option

Read More: [Solved]: Track Changes Not Showing in Excel

Things to Remember

  • If you want to track your changes in a workbook don’t forget to save the workbook on your network drive or inside your system. After saving you will be able to track changes correctly.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


In this article, I have tried to cover all the methods to solve track changes greyed out in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

  1. While I appreciate your website’s offer of free advice, I believe you missed a key element on this page. I’m not sure which version of Excel you’re using, but I have Office 365 at work and the Review ribbon looks different today (March 2024). There is only a “Show Changes” button, and it was greyed out until I saved my file onto a OneDrive location. Then, it became available.

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Mar 20, 2024 at 5:47 PM

      Dear Brent Hamilton

      Thanks for visiting our blog. You’re right; the article was described based on an older version of MS 365, likely pre-dating March 2024.

      From now on, in Excel 365, the Track Changes functionality has been integrated into the Show Changes button. It is important to note that saving the file to OneDrive is a prerequisite for using this feature.

      Lutfor Rahman Shimanto

    • Hello Brent Hamilton,

      Thank you for your feedback. We used Microsoft 365 at work. We apologize for any confusion caused. The reason the “Show Changes” feature only becomes available after saving the file on OneDrive for real-time collaboration and tracking of changes. If you save it on OneDrive, it allows Excel to track changes made by different users and enables the “Show Changes” feature to display those revisions. This integration with OneDrive enhances collaboration and ensures that users can effectively manage changes made to shared documents.


Leave a reply

Advanced Excel Exercises with Solutions PDF