When multiple people edit a shared Excel file, it can be difficult to know who made which changes. You might see different numbers or formulas without knowing who updated them. Excel has a built-in feature called Track Changes that records every edit. This article explains how to turn on change tracking and review the history of modifications in a shared workbook.
Key Takeaways: Tracking Edits in Shared Excel Workbooks
- Review > Track Changes > Highlight Changes: Enables a log that records the editor’s name, date, time, and the old and new value for each cell.
- Review > Track Changes > Accept/Reject Changes: Lets you review the history list and approve or undo specific edits made by collaborators.
- File > Info > Version History: Shows a list of automatically saved versions in OneDrive or SharePoint, allowing you to restore a previous file state.
How Excel’s Track Changes Feature Works
The Track Changes feature in Excel creates a detailed audit trail. When enabled, it monitors the workbook and logs every change to a cell’s content, formula, or formatting. For each edit, it stores the username of the person who made the change, the exact date and time, the cell address, the previous value, and the new value. This history is stored within the workbook file itself.
This feature is different from the simple change highlighting in newer versions of Excel for Microsoft 365. The classic Track Changes requires the workbook to be shared first, which creates a special multi-user file. Once shared and tracking is on, all users who open the file contribute to a single change history. You can later review this list and decide to accept or reject individual changes.
Prerequisites for Using Track Changes
To use the full Track Changes feature, your workbook must be saved in the older .xls format or as a shared workbook. The modern .xlsx format does not support the legacy shared workbook feature. You must first convert your file. Also, all users need to save the file to a shared network location or a cloud service like OneDrive or SharePoint that all editors can access.
Steps to Enable and Review Tracked Changes
Follow these steps to turn on change tracking and examine the edit history.
- Share the workbook
Open your Excel file. Go to the Review tab on the ribbon. Click the Share Workbook button. In the dialog box, check the box labeled ‘Allow changes by more than one user at the same time’. Click OK. Excel will prompt you to save the file; confirm to save it as a shared workbook. - Enable Track Changes
While still on the Review tab, click the Track Changes button, then select Highlight Changes from the dropdown menu. In the Highlight Changes dialog, check the box for ‘Track changes while editing. This also shares your workbook’. Ensure the ‘When’ dropdown is set to ‘All’. Check the boxes for ‘Who’ (set to ‘Everyone’) and ‘Where’. You can leave the ‘Highlight changes on screen’ box checked to see colored borders around edited cells. Click OK. - View the change history
To see all recorded edits, go back to Review > Track Changes and select Highlight Changes. In the dialog, check the ‘List changes on a new sheet’ option. Click OK. Excel will insert a new worksheet named ‘History’ into your workbook. This sheet lists every change in a table with columns for the change number, date, time, who made it, the cell changed, the old value, and the new value. - Accept or reject specific changes
To approve or undo edits, go to Review > Track Changes and select Accept/Reject Changes. Click OK in the prompt. A dialog box will appear showing the first change. You can click Accept to keep the change, Reject to revert the cell to its old value, Accept All to approve all remaining changes, or Reject All to undo them all.
Common Mistakes and Limitations to Avoid
Track Changes Option is Grayed Out
If the Track Changes button is unavailable, your workbook is likely saved in the .xlsx format. The legacy shared workbook feature only works with the .xls format. Save a copy of your file using File > Save As and choose ‘Excel 97-2003 Workbook (*.xls)’ as the file type. Then try enabling sharing and Track Changes again.
History Sheet Disappears After Saving
The History sheet that lists changes is temporary. Excel automatically removes it when you save the workbook. To review changes again, you must re-create the history list by going to Review > Track Changes > Highlight Changes and checking ‘List changes on a new sheet’. The data is still stored in the file; you are just generating a new report.
Certain Features Are Disabled in Shared Workbooks
When a workbook is shared to allow Track Changes, you cannot use all Excel features. You cannot create or edit certain objects like tables, PivotTables, or structured references. You also cannot merge cells, insert or delete blocks of cells, or use some drawing tools. Plan your workbook structure before sharing it.
Track Changes vs. Version History for Cloud Files
| Item | Track Changes (Legacy Shared Workbook) | Version History (OneDrive/SharePoint) |
|---|---|---|
| File Format | Requires .xls or shared workbook format | Works with modern .xlsx format |
| Change Detail | Logs per-cell edits with old/new values | Saves complete file snapshots |
| Review Process | Accept/Reject changes individually within Excel | Compare and restore entire previous file versions |
| Collaboration | Multiple users can edit simultaneously in the same file | Auto-save and co-authoring with live presence |
| Primary Use Case | Auditing specific cell-level edits and approving them | Recovering from major errors or viewing file evolution |
You can now monitor all edits in a shared Excel workbook and identify who made each change. Use the Accept/Reject Changes dialog to finalize the data in your file. For workbooks saved on OneDrive, also explore File > Info > Version History as a complementary tool. Remember to save your final workbook as a regular .xlsx file after reviewing changes to restore all Excel features.