Excel Track Changes Greyed Out? Fix It Here

Errors & fixes · Updated November 22, 2026

Excel’s Track Changes feature is greyed out because it is only available when the workbook is saved in the legacy .xls format, or because the feature has been replaced by Co-authoring in Microsoft 365. To fix it, save your workbook as an Excel 97-2003 Workbook (.xls) via File > Save As, then go to Review > Track Changes > Highlight Changes. However, note that this legacy feature is hidden by default in newer versions and is not supported in Excel for the web or on Mac.

Why Track Changes Is Greyed Out

The most common reason is file format. Track Changes (also called Shared Workbook) was designed for Excel 2007 and earlier. When you save a file as .xlsx, Excel disables the feature because it conflicts with modern collaboration features. Microsoft officially deprecated Track Changes in Excel 2019 and later, replacing it with co-authoring, which lets multiple people edit the same file simultaneously without locking it. If you are using Microsoft 365, the Track Changes button may be greyed out even on .xls files because the feature is hidden by default—you must add it to the Quick Access Toolbar manually.

How to Enable Track Changes (Step-by-Step)

  1. Open your workbook in Excel for Windows (Microsoft 365 or Excel 2016–2024).
  2. Click File > Save As and choose Excel 97-2003 Workbook (.xls) as the file type. Save it to a new name if you want to keep the original .xlsx.
  3. Click File > Options > Quick Access Toolbar.
  4. In the “Choose commands from” dropdown, select All Commands.
  5. Scroll to Track Changes (Legacy) and click Add, then OK.
  6. Now click the Track Changes icon on the Quick Access Toolbar, then choose Highlight Changes.

On Mac, Track Changes is not available at all in Excel 2016 or later. The only way to see edits is to use co-authoring or the “Show Changes” pane (Review > Show Changes), which works on .xlsx files but does not allow the old “accept/reject” workflow.

What Track Changes Actually Does

When enabled, Track Changes records every edit—cell value changes, insertions, deletions, and formatting changes—with the user’s name and a timestamp. Each changed cell gets a colored border and a small triangle in the corner. You can review changes by clicking Review > Track Changes > Accept/Reject Changes. This feature also enables the “Shared Workbook” mode, which allows multiple users to edit the same file on a network drive, but it locks the file and prevents modern features like tables, conditional formatting with dynamic arrays, and Power Query.

Common Problems Beyond Greyed Out

  • Changes not highlighted: If you enable Track Changes but don’t see any markers, go to Review > Track Changes > Highlight Changes and check “When” and “Who” filters. Also ensure the workbook is not in compatibility mode.
  • Cannot accept/reject changes: You must be the owner of the workbook or have the file open exclusively. If it’s shared, only the person who made the change can accept/reject it unless you unshare first.
  • Track Changes disappears after saving: Saving as .xlsx automatically removes the feature. You must keep the file as .xls permanently.
  • Excel freezes or slows down: Track Changes stores a large history log. Over time, this can bloat the file. You can clear the history by going to Review > Track Changes > Highlight Changes and unchecking “List changes on a new sheet.”

Track Changes vs. Co-Authoring (Modern Alternative)

Microsoft 365’s co-authoring is the official replacement. When you save a file to OneDrive or SharePoint, multiple people can edit simultaneously. To see who changed what, go to Review > Show Changes (Windows only). This opens a side pane showing each edit with the user’s name and time. You can click on a change to see it in the grid, but you cannot accept or reject individual changes—you must manually undo them. Co-authoring works on .xlsx files, supports all modern features, and is available on Mac and Excel for the web. For strict audit trails, you should use File > Info > Version History to view or restore older versions.

How to Choose Between Track Changes and Co-Authoring

Use Track Changes if you need a formal accept/reject workflow, you are working on a local network drive, or you need to track edits in a file that others will not have write access to simultaneously. Use co-authoring if you want real-time collaboration, you are using Microsoft 365, and you do not need to formally approve each change. For most modern teams, co-authoring is the better choice because it is faster and does not break features like XLOOKUP or dynamic arrays. If you absolutely need accept/reject, consider using a third-party add-in or moving the review process to a tool like SharePoint’s approval workflow.

Frequently Asked Questions

Why is Track Changes greyed out in Excel 365 even on .xls?
Because Microsoft hid the button from the ribbon. You must add “Track Changes (Legacy)” to the Quick Access Toolbar via File > Options. The feature still works, but it is not supported on Mac or Excel for the web.

Can I use Track Changes on a Mac?
No. Excel for Mac does not include the legacy Track Changes feature. Use co-authoring with Show Changes (available in Excel 365 for Windows only) or use Google Sheets’ version history if you need cross-platform tracking.

Does Track Changes work in Excel for the web?
No. The web version only supports co-authoring. You can view version history but not the old accept/reject interface.

How do I remove Track Changes from a workbook?
Go to Review > Track Changes > Highlight Changes and uncheck “Track changes while editing.” Then save the file as .xlsx. This permanently removes the history log and unlocks the file from shared mode.

Will Track Changes work if I share the file via OneDrive?
Yes, but only if the file is saved as .xls and you use the legacy shared workbook mode. However, OneDrive co-authoring will not work simultaneously with Track Changes—you must choose one.

Is there a way to see changes without Track Changes?
Yes. Use Review > Show Changes (Windows only) to see a list of recent edits in a side pane. Also, File > Info > Version History lets you compare or restore older versions. For a permanent audit trail, use a database or a dedicated change-tracking tool.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.