THE EXCEL GUIDE Mastering Data & Spreadsheets

Home
Productivity and Tips

Track Changes in Excel: Shared File Guide (2026)

Learn how to monitor edits and revisions.
By:

Most people think track changes in Excel works the same way it always did: you flip a switch, edits get flagged, done. That's not true anymore, and the version you're running changes everything about how this works. I've watched colleagues spend twenty minutes hunting for a button that's been redesigned out of its original location, or worse, enable the legacy method on a file that three people are actively editing in Microsoft 365. The result is either a broken workflow or change history that quietly stops recording. Before touching any settings, you need to know which system you're actually in.

This guide covers both paths: the modern Microsoft 365 co-authoring approach and the older shared workbook method for teams still on Excel 2019 or earlier. It also addresses the questions flooding forums right now — why the Track Changes button is greyed out, what happened to it in newer Excel versions, and how to resolve conflicts when two people edit the same cell at the same time.

Track Changes button in legacy Excel 2019 versus Show Changes option in Microsoft 365
The Track Changes button you remember looks different — or is missing entirely — depending on which version of Excel you're running.

Modern Excel vs. Legacy Excel: Which Version Are You Actually Using?

If you're on Microsoft 365 (the subscription version), your Excel has co-authoring built in, and Microsoft has largely replaced the old Track Changes panel with a feature called Show Changes. The classic Track Changes option still exists, buried under the Review tab, but it behaves differently than it did in Excel 2019 and doesn't interact well with co-authoring. If you're on a standalone license (Excel 2019, 2021, or anything Office-branded before the Microsoft 365 subscription model) the legacy method still applies to you.

Not sure which you have? Go to File > Account. If you see a "Microsoft 365" product name and an update channel, you're on the subscription version.

The OneDrive or SharePoint Prerequisite Most Guides Skip

If your file isn't saved to OneDrive or SharePoint, modern co-authoring and version history won't work. The file has to live in the cloud for Microsoft 365's change-tracking features to function. A local save to your desktop or a mapped network drive won't cut it.

This is the single most common reason the relevant options are greyed out or missing. Check how to save an Excel file to OneDrive if you haven't done that yet. It's the foundation everything else sits on.

Step 1: Turn On Change Tracking for Your Shared Workbook

Once you've confirmed your version and, if you're on Microsoft 365, that the file is saved to OneDrive or SharePoint, you're ready to enable tracking. The process splits cleanly depending on which Excel you're running.

Modern Excel 365: Using Version History and AutoSave

In Microsoft 365, AutoSave handles the continuous save that makes change tracking possible. Make sure AutoSave is toggled on in the top-left corner of Excel (it only activates for cloud-saved files). Once it's on:

  1. Go to the Review tab.
  2. Click Show Changes. This opens a pane listing every edit made to the file, with the editor's name, the cell reference, and the previous value.
  3. For full version history, go to File > Info > Version History. This shows timestamped snapshots you can open and restore.

There's no "enable" step here. If AutoSave is on and the file is in the cloud, the change history log is being written automatically. You're just learning where to read it.

Legacy Excel: Enabling Track Changes Through the Shared Workbook Setting

For Excel 2019 and earlier, the process is different. The legacy Track Changes system ties directly into the shared workbook setting:

  1. Go to the Review tab and click Share Workbook. (You may need to add this to the ribbon via File > Options > Quick Access Toolbar.)
  2. Check the box that says "Allow changes by more than one user at the same time."
  3. Then go to Track Changes > Highlight Changes. Set it to track changes while editing, and choose whether to highlight them on screen.

This creates a change history log stored on a hidden sheet. It works, but it's limited: the history defaults to 30 days, and some formatting changes won't be logged at all.

Step 2: See Who Changed What, Then Accept or Reject Changes Without Overwriting Your Team's Work

With tracking active, the next issue is reading what changed and deciding what to keep. This is where most guides go shallow, and where real team workflows get messy.

Reading the Change History Log and Color-Coded Highlights

In legacy Excel, cells with tracked edits show color-coded borders (each collaborator gets a different color). Hover over a flagged cell and you'll see a tooltip showing who changed it, when, and what the previous value was. In Microsoft 365's Show Changes pane, the same information appears in list form, filterable by sheet or by person.

To pull the full change history log into a readable sheet in legacy Excel: go to Track Changes > Highlight Changes and check "List changes on a new sheet." That gives you a table you can sort and filter.

How to Accept or Reject Changes — and Who Has Permission to Do It

In a legacy shared workbook, any user in the share list can accept or reject anyone else's changes. There's no permission hierarchy. A junior team member can silently accept edits the file owner hasn't reviewed yet.

I've seen this cause real problems during month-end reporting: a change gets accepted by the wrong person before it's been validated, and by the time someone notices, the audit trail is gone.

To accept or reject in legacy Excel: go to Review > Track Changes > Accept/Reject Changes. In Microsoft 365, version history lets you restore a prior snapshot, but there's no native accept/reject workflow in the same sense. If you need that level of control, a protected sheet with edit permissions locked to specific users is a stronger structural fix than relying on change tracking alone. That pairs well with the broader practices in Excel file management and sharing.

The permission gap is an architecture problem, not a user behavior problem. Build the file so it controls what people can do, not just what they did.

Common Mistakes That Break Change Tracking in Excel

If you've ever opened a shared file and found the Track Changes option greyed out, you've hit the most common stumbling block. Here's what's actually happening, and how to fix each scenario.

Why is Track Changes greyed out in Excel?

In Microsoft 365, it's almost always because the file isn't saved to OneDrive or SharePoint. Save it to the cloud first, and the options unlock. In legacy Excel, it usually means the workbook contains a table object, which is incompatible with shared workbook mode. Convert any tables to ranges before enabling sharing.

Two people edited the same cell at the same time

Excel flags this as a conflict on save. In legacy shared workbooks, Excel shows a conflict resolution dialog where you choose which version to keep. In Microsoft 365 co-authoring, changes sync in near-real-time, so conflicts are rarer — but when they do happen, the last save wins unless you catch it in version history. There's no automatic merge for cell-level conflicts.

Moving the file off OneDrive breaks the history

If someone downloads the file locally and re-uploads it, the version history chain breaks. The new upload starts a fresh history. This happens more than you'd think, especially when someone wants to email the file instead of sharing a link. A filename like Final_v3_REVISED_ACTUALLY_FINAL.xlsx in your inbox is a reliable sign the team has lost track of the authoritative version. File naming conventions that include version numbers help surface when this is happening.

A structural alternative: Power Query with AutoSave

If your team pulls data from a shared source file, building a Power Query pipeline with AutoSave enabled on the output file means accidental edits to the output don't touch the source. The data flows one direction, which eliminates a whole category of shared-file change problems without relying on tracking at all.

In my experience, the teams that maintain clean shared files aren't the ones with the most sophisticated tracking setup. They're the ones with the simplest setup that everyone actually checks. A version history nobody reviews is just decoration.

Frequently Asked Questions

Why is Track Changes greyed out in Excel?

In Microsoft 365, the option is greyed out when the file isn't saved to OneDrive or SharePoint — the cloud connection is required. In legacy Excel, it usually means the workbook contains a table object, which is incompatible with shared workbook mode. Convert any tables to ranges first, then try enabling it again.

What happened to the Track Changes button in modern Excel?

Microsoft replaced the classic Track Changes workflow with Show Changes in Microsoft 365 as part of the shift to co-authoring. The old button still exists on the Review tab but is partially deprecated — it doesn't integrate cleanly with the co-authoring model. Show Changes and Version History are the intended replacements.

Does Excel track changes automatically when saved to OneDrive?

Yes — when AutoSave is enabled and the file is stored in OneDrive or SharePoint, Microsoft 365 logs changes continuously through the Show Changes feature and builds a version history automatically. You don't need to manually enable anything beyond AutoSave being on.

How do I resolve conflicts when two people edit the same cell?

In legacy shared workbooks, Excel shows a conflict dialog on save that lets you choose which version to keep. In Microsoft 365 co-authoring, conflicts are less common because edits sync in near-real-time, but when they occur, the last save wins. Version history lets you restore an earlier state if something gets overwritten incorrectly.