editwhe.blogg.se

You can see that the option under the command will appear dimmed in color. To turn on the disabled track changes option open a worksheet and follow these options: Tools> Track Changes > Highlight Changes. You can’t change or create pivot tables using the slicersĢ# Turn On The Disabled Track Changes Option.Nor you can use the automatic subtotals.Assign, change, or remove passwords, protect or unprotect sheets.can’t Insert hyperlinks, drawing objects.

So that everyone has the access to edit the worksheet data.Īs such things happen because the shared workbook function has so many limitations. To avoid such kind of problem, before turning on the file-sharing option, just save your workbook on a network drive within a folder. How To Fix Excel Track Changes Grayed Out Issue? 1# Remove The Shared ModeĪs we all already discussed that Excel track changes grayed out also when the workbook is in shared mode. Preview the repaired files and click Save File to save the files at desired location.Select the corrupt Excel file (XLS, XLSX) & click Repair to initiate the repair process.Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.But if in case you want to prevent users from doing such changes then apply the password before sharing the workbook. Users can also make remove or modify the tracked changes. Thus any changes done before turning on this Excel tracking option will not be tracked. Among these features, the Excel track changes option is also the one that becomes unavailable.Īnother reason can be that your Excel Track Changes option is disabled. When a workbook is shared, most of Excel’s editing feature gets unavailable. The very first reason behind the Excel Track Changes option not working is the sharing of the workbook. Source: Why Excel Track Changes Option Grayed Out ? So there is something in this sheet which is causing track changes to be grayed out.

This workbook contains 5 worksheets, so I tried moving (copying) each sheet to a new workbook, and I found that when I copy one particular sheet, track changes option gets grayed out in the new workbook.

I tried searching, but couldn’t find any solution. However track changes button is grayed out. I have an excel workbook (.xlsx) in which I want to track changes.