To disable Excel’s legacy Track Changes feature in Microsoft 365 for Windows, open the workbook, go to Review > Track Changes > Highlight Changes, clear “Track changes while editing,” and confirm the prompt. Before doing that, save a separate copy if you may need the old change history: turning off legacy tracking can remove that history. Excel’s newer coauthoring and version history are different features and are not switched off by this setting.
The steps below apply to the older Track Changes feature used with a shared workbook. The command may be hidden in current Excel versions, so the guide also explains how to add it and what to check if what you see is “Show Changes” instead.
What You’ll Need
- Excel for Microsoft 365 on Windows. The legacy Track Changes controls are not available in the same way in Excel for the web or Excel for Mac; use the Windows desktop app for the procedure below.
- Edit permission for the workbook. If it is read-only, protected, or controlled by your organization, you may not be able to change its sharing or tracking settings.
- A backup if the change history matters. Save a separate copy before turning tracking off. If the workbook is stored in OneDrive or SharePoint, you can also check its version history, but do not rely on that as a replacement for the legacy change log.
Step-by-Step
- Identify which kind of change tracking you mean. Open the file in Excel for Microsoft 365 on Windows. If cells have colored borders or comments indicating edits and the workbook uses the old Shared Workbook feature, it may be using legacy Track Changes. If you see a Review > Show Changes pane for a modern coauthored file, that is a different feature. The legacy instructions below will not turn off modern coauthoring or its edit history.
- Save a backup copy before changing the setting. Choose File > Save As and save another copy with a distinct name, such as “Budget before tracking disabled.xlsx.” If the file is in OneDrive or SharePoint, you can also use the file’s version history as an additional recovery option. Keep the backup somewhere you can find it and do not overwrite it with the updated workbook.
- Look for the legacy command on the Review tab. Select Review and check for Track Changes or Highlight Changes. If Track Changes is visible, choose Track Changes > Highlight Changes. In some Excel builds, the command is shown directly as Highlight Changes (Legacy). Select that command to open the Highlight Changes dialog box. Menu names can vary slightly by build, but look specifically for the legacy Highlight Changes command—not Show Changes.
- Add the command if it is missing. In Excel for Windows, choose File > Options > Customize Ribbon. In the “Choose commands from” list, select “All Commands.” Find “Track Changes (Legacy)” or “Highlight Changes (Legacy),” depending on what your build lists. In the right-hand list, select a custom group on the Review tab, or create one with New Group, then choose Add and OK. Return to Review and open the command you added. If neither legacy command appears, check that you opened the desktop app and that the workbook is not being edited in the browser.
- Turn off tracking in the dialog box. In Highlight Changes, clear the checkbox labeled “Track changes while editing. This also shares your workbook.” Do not just clear “Highlight changes on screen”: that option only controls whether edits are visually marked, not whether Excel records them. The tracking checkbox is the setting that disables the legacy feature.
- Confirm Excel’s warning. Excel may explain that turning off tracking also stops sharing the workbook or removes its change history. Read the prompt before choosing Yes. If you still need to inspect, accept, or reject past edits, cancel, return to the workbook, and review them first. When you are ready to proceed, confirm the prompt to stop legacy tracking.
- Save and verify the result. Save the workbook, close it, and reopen it if practical. Return to Review and check the legacy Highlight Changes dialog; the “Track changes while editing” box should remain cleared. If another user edits the workbook afterward, verify that the file is no longer using the old shared-workbook tracking mode. Modern version history may still show saved versions, which does not mean legacy Track Changes is still on.
If Excel asks whether to save changes while closing, save the workbook. Avoid using Save As to overwrite the backup you made. When several people have the file open, ask them to close it or coordinate a short editing pause; otherwise another person’s open session or a read-only state can prevent you from applying the setting cleanly.
Common Mistakes
- Confusing “Show Changes” with legacy Track Changes. Show Changes is part of modern coauthoring. It displays recent edits but has no checkbox that switches off recording in the same way. Disabling the old shared-workbook feature does not erase Microsoft 365 version history or stop coauthoring.
- Hiding edit marks instead of stopping tracking. The Highlight Changes dialog includes display choices. Unchecking “Highlight changes on screen” only hides the visual indicators; tracking may continue. Clear the main “Track changes while editing” checkbox instead.
- Turning tracking off before reviewing the log. The legacy change history can be lost when the feature is disabled. If you need to know who changed a value, or to accept or reject edits, make a backup and review the changes before confirming the warning.
- Assuming comments or notes are tracked edits. Cell comments, threaded comments, and notes are separate workbook content. Disabling legacy Track Changes does not necessarily remove them. Delete or resolve comments individually only if that is your intention.
- Trying to change the setting in the browser or on a Mac. The desktop Windows legacy controls are not reproduced consistently on those platforms. Open the file in Excel for Windows and use the legacy command, or ask a workbook owner or administrator with access to do it.
- Expecting the change to prevent every kind of edit record. Stopping legacy tracking does not disable AutoSave, cloud version history, or collaboration features. These may continue to retain versions or show edits under their own rules.
Tips
- Keep the original and the updated copy clearly named. A dated backup makes it easier to distinguish the workbook with its old tracking history from the one where tracking is disabled. Avoid names such as “final final,” which are difficult to identify later.
- Check with collaborators before stopping shared-workbook tracking. The legacy setting is associated with the old shared workbook workflow. Disabling it can affect how other users work with the file, so agree on a time to make the change and tell collaborators when the updated copy is ready.
- Use version history for a different purpose. In a OneDrive or SharePoint file, version history can help restore an earlier saved version. It is not the same as the cell-by-cell legacy change log, and it may not answer exactly who changed a particular cell or when.
- Review protection and permissions separately. Turning off tracking does not unlock protected cells, remove a password, or grant edit permission. If you cannot save changes afterward, check the workbook’s protection and file permissions rather than repeatedly toggling tracking.
- Make the distinction clear in team instructions. If people mean the modern Show Changes pane when they say “track changes,” explain that it is an edit-review feature for coauthored files, not the legacy on/off switch. This prevents someone from disabling the wrong workbook feature or expecting the history to disappear.
Troubleshooting
The Highlight Changes option is missing. First confirm that the workbook is open in the Windows desktop app, not Excel for the web. Then add the legacy command through File > Options > Customize Ribbon as described above. If the commands are absent from “All Commands,” your Excel build, file type, or organization’s configuration may not support the legacy workflow. Ask your administrator or workbook owner whether the file is using an older shared-workbook setup.
The checkbox is unavailable or Excel will not save the change. Check whether the file is read-only, opened from a location where you lack write access, or protected by workbook settings. Use File > Save As to create an editable local copy if policy allows, then try the setting on that copy. If several people have the workbook open, coordinate with them and ask them to close it before retrying. A protected worksheet is different from a shared workbook, so removing sheet protection may require the owner or password.
Excel warns that history will be removed. Cancel if you are unsure. Save a copy, then inspect and preserve the information you need before returning to Highlight Changes. If the dialog provides options to review changes, use them before switching tracking off. The warning is important: do not assume the history can be reconstructed from the disabled workbook afterward.
You still see edits after turning tracking off. The marks may be comments, notes, formatting, or modern coauthoring indicators rather than legacy tracked changes. Check whether Review > Show Changes opens a pane, and check the file’s version history if it is stored online. Those features have separate controls and retention behavior; the legacy checkbox does not turn them off.
The workbook still appears shared or behaves differently. Save, close, and reopen it, then inspect the legacy tracking setting again. If the file is still in the old shared-workbook mode or collaborators cannot edit as expected, confirm with its owner whether the workbook should remain shared. Do not convert formats or remove sharing without a backup and agreement from the people who depend on the file.
Frequently Asked Questions
Does disabling Track Changes delete the old change history?
It can. Excel may warn that history will be removed when you turn off the legacy feature. Make a separate copy and review or preserve needed information before confirming; do not treat the warning as a routine prompt.
Will turning it off stop Excel from saving versions?
No. Disabling legacy Track Changes is separate from AutoSave and cloud version history. A OneDrive or SharePoint workbook may still have saved versions, and modern coauthoring can still be available.
Can I disable Track Changes in Excel for Mac or Excel for the web?
The legacy Windows controls described here are not available in the same way in Excel for Mac or the web app. Open the workbook in Excel for Microsoft 365 on Windows and use the legacy Highlight Changes command. Mac and web users can encounter modern Show Changes, which is a different feature.
Why do I still see “Show Changes” after turning tracking off?
Show Changes belongs to modern coauthoring and is not the legacy tracking checkbox. Its presence does not by itself show that the old shared-workbook feature is enabled. Check the legacy Highlight Changes dialog to verify that its tracking box is cleared.
Does disabling tracking accept or reject the edits already listed?
Do not assume it does. Review and accept or reject any pending legacy edits before turning tracking off, especially if the decisions matter. Save a backup first because the history may no longer be available after tracking is disabled.
Can I turn legacy Track Changes back on later?
If the command remains available, you may be able to enable it again through Highlight Changes, but this does not restore history that was removed when tracking was disabled. Re-enabling the feature records future edits; it is not a way to recover the old log.
Related
- Excel AutoSave: How to Turn It Off and Keep Changes Safe
- Delete a Protected Sheet in Excel: Steps and Fixes
- How to Delete Only Visible Rows in Excel Without Hidden Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Table Formatting Tips for Clearer, Easier DataFor clear, reliable Excel table formatting, convert your data range into a table with Ctrl+T, confirm that the…
- Create an Envelope Template in Word: A Practical GuideIn Microsoft Word for Microsoft 365 on Windows, go to Mailings > Envelopes, enter the delivery and return…
- Track Changes Options in Microsoft Word: Where to Find ThemTo get to Track Changes options in Microsoft Word for Microsoft 365 on Windows, open the document, select…
- Excel Column Calculator: Convert Numbers to LettersAn Excel column calculator converts a column number to its letter label, or converts a label such as…
- Excel Slicers: A Clear Guide to Filtering DataIn Excel for Microsoft 365 on Windows, a slicer is a set of clickable buttons that filters a…
- VBE Editor in Windows: Name, Access, and UsesThe VBE editor in Windows is the Visual Basic Editor, commonly called the VBA Editor. It is the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.