Why is track changes greyed out in excel 2010

It may not display this or other websites correctly. You should upgrade or use an alternative browser. Track Changes greyed out. Thread starter jessicaht Start date Jul 19, Joined Jul 12, Messages 3. I'm using Excel with a power query data connection to create my table.

I want to be able to track changes but the button is greyed out - is this intentional with the workbook in the way I've set it up or is it a setting I can change somewhere? Excel Facts. How can you turn a range sideways? Click here to reveal answer. Copy the range. Select a blank cell. Cancel Submit.

Robelene Win Microsoft Agent. Hi, To address your concern, kindly refer to this link regarding track changes in a shared workbook in Excel for Windows. Let us know if you have any other questions. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. A subscription to make the most of your time. Larger Image. Finally I found answer to the solution. Apparently the track changes option is disabled grayed out if any of the sheet contains a table.

There was one table in one of the sheets of the workbook. When I changed the table back to range, I was able to track changes. Sign up to join this community. The best answers are voted up and rise to the top.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Track Changes button grayed out excel Ask Question.

Asked 5 years, 8 months ago. Another reason can be that your Excel Track Changes option is disabled. Thus any changes done before turning on this Excel tracking option will not be tracked.

Users can also make remove or modify the tracked changes. But if in case you want to prevent users from doing such changes then apply the password before sharing the workbook.

As we all already discussed that Excel track changes grayed out also when the workbook is in shared mode. To avoid such kind of problem, before turning on the file-sharing option, just save your workbook on a network drive within a folder. So that everyone has the access to edit the worksheet data. As such things happen because the shared workbook function has so many limitations. You can see that the option under the command will appear dimmed in color. After that click on the down arrow present next to When , Who, and Where.

Before putting any option from your side explore the default option first. Suppose, in case you want to monitor the complete worksheet then left uncheck the Where option.

But to monitor only a specific section of your worksheet fill the Where option and check that section too.