Not all changes are tracked in ExcelĮxcel does not track every single change. You can manually review those changes and choose which ones to keep and which ones to override. Excel's Track Changes is rather a log file that records information about the changes made to a workbook. In Microsoft Excel, you cannot revert the worksheet back in time by undoing changes like you can do in Microsoft Word. It's not possible to undo changes in Excel In that case, convert your tables to ranges and remove XML maps. 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. Track Changes cannot be used in workbooks that contain tables For more information, please see our Excel shared workbook tutorial. Not all Excel features are fully supported in shared workbooks including conditional formatting, data validation, sorting and filtering by format, merging cells, to name a few. That sounds great, but sharing a file has its drawbacks too. So, whenever your turn on tracking in Excel, the workbook becomes shared, meaning that multiple users can make their edits simultaneously. Track Changes is only available in shared workbooksĮxcel's Track Changes works only in shared workbooks. To use the Excel tracking feature most effectively, there are a few points for you to remember.

Set for how long the change history should be keptīy using the built-in Track Changes in Excel, you can easily review your edits directly in the edited worksheet or on a separate sheet, and then accept or reject each change individually or all changes at a time.

View changes history in a separate sheet.

Furthermore, you can monitor the latest changes by using the Watch Window.

In an Excel file, you can review, accept or reject changes electronically by using the Track Changes feature specially designed for it. On a printed copy, you could use a red pen to mark edits. This could be especially useful when the document is almost finished and your team is making the final revisions.

When collaborating on an Excel workbook, you may want to keep track of the changes that have been made to it. The tutorial shows how to track changes in Excel: highlight changes on screen, list changes in a separate sheet, accept and reject changes, as well as monitor the last changed cell.

How to keep on track with something