Excel Track Changes: How to Turn It On

To turn on the traditional Track Changes mode in Excel for Microsoft 365 on Windows, open the workbook, go to Review > Track Changes (Legacy) > Highlight Changes, select Track changes while editing, and choose OK. This legacy feature records edits in a shared workbook; for most current collaboration, Excel’s Review > Show Changes is the simpler alternative. Save a copy first, because the legacy shared-workbook feature has limitations.

What You’ll Need

Excel for Microsoft 365 desktop on Windows. The steps below are for this version; Excel for the web and Mac use different collaboration options.
A workbook saved as an Excel file, such as .xlsx, and permission to edit it. Keep an untouched backup before enabling legacy sharing.
If other people need to edit the file, a location they can access. For a new collaborative workbook, OneDrive or SharePoint with coauthoring is generally preferable to the legacy shared-workbook system.

Step-by-Step

Save a separate copy. Use File > Save As and give the working copy a clear name. Track Changes (Legacy) puts the workbook into an older shared-workbook mode, which disables or restricts some Excel features. A backup gives you a clean version to return to if the workbook behaves differently than expected.
Check the Review tab. Open the copy and select Review on the ribbon. Look for Track Changes (Legacy). In some Microsoft 365 installations, the legacy commands are hidden and this option is not shown by default. Do not confuse it with Show Changes: they are separate features with different purposes.
Add the legacy command if it is missing. Select File > Options > Customize Ribbon. In the Choose commands from list, select All Commands. In the right-hand list, select the Review tab, create a New Group, and select Add to put Track Changes (Legacy) in that group. You can rename the group if you want. If Excel also needs the sharing command, add Share Workbook (Legacy) in the same way. Select OK to return to the workbook. The custom group is where you will find the command; it may not appear in the ribbon’s original Review groups.
Open Highlight Changes. Select Review > Track Changes (Legacy) > Highlight Changes. If you just added the command, choose it from your new Review group. Excel opens a dialog with settings for tracking and displaying edits. If Excel asks you to save the workbook or enable sharing, follow the prompt, keeping in mind that this is the legacy sharing feature.
Turn tracking on. In the Highlight Changes dialog, select Track changes while editing. This also shares your workbook. That checkbox is the key setting: merely opening the dialog or choosing how changes are highlighted does not start tracking. Select OK to apply the setting, and confirm any notice about saving or sharing.
Choose what to display. The dialog may let you filter the displayed changes by when they were made, who made them, or which cells were edited. For an initial check, leave the filters broad so you do not accidentally hide relevant edits. If the option is available, List changes on a new sheet creates a worksheet-style list of recorded changes when you display them; it is a report, not a replacement for a backup.
Save and verify with a small edit. Save the workbook, change a test cell with a simple value, and save again. Reopen Highlight Changes and check that the edit appears. If other people will edit the file, ask one of them to make a clearly identifiable test change as well. Confirm that the right cell, editor, and time are shown before relying on the log.
Share the file carefully. Give collaborators access to the same shared workbook and explain that this is the older sharing mode. Avoid making simultaneous structural changes, such as adding or changing features that legacy shared workbooks do not support. When you finish tracking, revisit the Highlight Changes dialog and clear Track changes while editing if you want to stop recording further edits.

For current coauthoring instead: Save the workbook to OneDrive or SharePoint, share it with the editors, and use Review > Show Changes to inspect recent edits. Show Changes can identify who changed a cell, what changed, where, and when. It is not a switch that turns on the legacy Track Changes mode, and it does not display the same kind of persistent, marked-up history. Microsoft says the Show Changes pane retains change history for up to 60 days.

Common Mistakes

Looking for the old command in the wrong place. Track Changes (Legacy) may be hidden, so repeatedly searching the Review ribbon will not reveal it. Add the command through File > Options > Customize Ribbon, or use Show Changes if you need modern coauthoring rather than the legacy tool.
Assuming Show Changes and Track Changes are identical. Show Changes is an inspection pane for recent edits in a coauthored workbook. Track Changes (Legacy) enables an older shared-workbook workflow. Turning on one does not automatically activate the other.
Turning on tracking but not saving or sharing correctly. The legacy feature is tied to sharing the workbook. If collaborators are opening separate copies, their edits will not all appear in one history. Make sure everyone is working in the same shared file.
Using the legacy mode on a feature-heavy workbook without checking first. Shared workbooks have restrictions, and some Excel features may be unavailable while the workbook is shared. Test the copy and check that essential formulas, formatting, and workbook features still work as expected.
Trusting filters that hide edits. A When, Who, or Where filter can make it look as if Excel recorded nothing. Clear or broaden the filters before concluding that tracking failed.

Tips

Choose the tool based on the job. For a team editing a current Microsoft 365 workbook, use OneDrive or SharePoint coauthoring and Show Changes. Use Track Changes (Legacy) only when you specifically need its older shared-workbook behavior or compatibility with an existing process.
Make the test change easy to recognize. Use a spare cell or a temporary value that will not affect calculations, then remove it after confirming the log works. Do not test by changing a live result or overwriting important data.
Agree on a workflow before sharing. Tell editors where the shared file is, whether they should avoid certain workbook changes, and who is responsible for reviewing edits. A change log is useful, but it is not a substitute for clear file ownership and backups.
Review the history soon. Open Highlight Changes and use the filters to narrow a review by editor, date, or range. For Show Changes, review the pane while the relevant changes are within its retention period.
Keep an original outside the shared copy. Store a dated backup in a controlled location. A history view can help explain edits, but it does not guarantee that every action can be reversed or that every version of a workbook is preserved.

Troubleshooting

Track Changes (Legacy) is missing from Review. In Windows desktop Excel, open File > Options > Customize Ribbon, set Choose commands from to All Commands, and add Track Changes (Legacy) to a custom group on the Review tab. If you are using Excel for the web, those Windows desktop Options are not available; use Review > Show Changes for recent coauthoring edits instead.

The checkbox is unavailable, or Excel says the command cannot be used. Confirm that you are working in desktop Excel for Windows and that you opened the legacy Highlight Changes dialog. Check whether the workbook is already shared, protected, or in a state that prevents editing. Save a copy, remove any protection only if you are authorized to do so, and try again. If the workbook relies on features that conflict with legacy sharing, use a normal coauthored copy and Show Changes instead.

No edit appears in the history. Save the workbook after making the test edit, reopen the dialog, and remove restrictive When, Who, or Where filters. Check that tracking was enabled before the edit and that you changed the shared file rather than a downloaded or emailed copy. Ask a collaborator to confirm the file path they used.

A collaborator cannot access the shared workbook. Verify that they have permission to the actual file and are opening that same location. Do not merge unrelated copies and assume their histories will combine automatically. If sharing permissions or legacy compatibility are causing repeated problems, save a clean copy to OneDrive or SharePoint and use modern coauthoring.

You are on a Mac or in a browser. The Windows File > Options ribbon-customization route does not apply to Mac or Excel for the web. Those platforms support modern collaboration features, but the legacy commands and shared-workbook workflow may not be available in the same way. Use Review > Show Changes if it is present, or open the file in Excel for Microsoft 365 on Windows to follow the legacy steps.

Frequently Asked Questions

Is Track Changes still available in Excel?
Yes, the legacy feature remains in Windows desktop Excel, but its commands may be hidden and it uses the older shared-workbook system. Microsoft 365 also has Show Changes for modern coauthoring.

Does Track Changes record edits automatically?
It records changes after Track changes while editing is selected and the shared workbook is saved. It does not reconstruct edits that happened before tracking was enabled.

Can I track changes in Excel for the web?
Excel for the web provides Show Changes for recent edits in coauthored workbooks. It does not provide the same legacy Track Changes setup described for Windows desktop Excel.

Can I use the legacy feature on a Mac?
The Windows ribbon-customization steps do not apply to Mac, and the legacy workflow may not be available there. For a Mac collaboration workflow, use a cloud-stored workbook and Review > Show Changes when available.

How do I stop tracking changes?
In Windows desktop Excel, open Review > Track Changes (Legacy) > Highlight Changes and clear Track changes while editing. Save the workbook. If you instead use Show Changes, there is no legacy tracking checkbox to turn off; that pane displays recent coauthoring history.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.