Track changes in Excel

Track changes in Excel: where it went, and what to use now

The classic Track Changes is hidden in modern Excel, and its replacement only works on files saved in OneDrive or SharePoint and edited online. Here’s exactly what each one does, where it stops, and how to see every change between two versions or two files.

Compare two files now See the platform

Classic “Track Changes” is a legacy feature now

If you remember Review → Track Changes → Highlight Changes, you remember a feature that rode on Excel’s old Shared Workbook mode. Microsoft replaced shared workbooks with real-time co-authoring, and in the process pulled the Track Changes buttons off the ribbon. The commands still exist — you can add them back from File → Options → Quick Access Toolbar — but they only work once you put the workbook into the legacy shared mode, which disables a long list of modern features in return.

Even when you turn it on, it was always thin: it highlights edited cells and keeps a change list that’s easy to lose, doesn’t track many kinds of structural change, and was never meant to compare two files you choose. For most people today it’s a relic, not a workflow.

“Show Changes” is the modern version, with strings attached

The current answer is Review → Show Changes. When a workbook lives in OneDrive or SharePoint and is edited online or in a recent desktop build, it opens a pane that lists recent cell edits: what changed, who changed it, and when. It’s the closest Excel gets to “see who changed what,” and for catching a recent edit it does the job.

The limits show up fast:

  • It only works for files stored in OneDrive or SharePoint — a workbook on your desktop or a network drive gets nothing.
  • It shows a feed of recent edits, not a comparison of two versions you pick — older changes age out of view.
  • It can’t compare two separate files, so budget_v2.xlsx against budget_v3.xlsx is out of reach.
  • It logs that a value changed, but won’t flag a formula being swapped for a typed-in number, or show inserted rows and renamed sheets.

Track Changes vs Show Changes vs SheetDelta

Two built-in features and a dedicated compare tool, side by side.

Track Changes (legacy)
Show Changes
SheetDelta
Available in current Excel Hidden
Works on a local file —
Compare two separate files — —
Compare any two saved versions — Recent edits only
Shows formula vs value changes Limited —
Detects inserted / deleted rows — —
Includes VBA / macro changes — —
Exportable record for an audit Fragile —

Show Changes is a useful live feed for OneDrive/SharePoint files. SheetDelta is for the other questions: what changed between these two versions, between these two files, and is it safe to ship.

When you need to compare, not just glance

Excel’s built-in tools answer “what did someone just edit in this file.” The harder question is usually “what changed between the version we signed off last month and the one in front of me now” — across two files, including formulas, inserted rows, renamed sheets, and macros. That’s what SheetDelta is for.

Drop two workbooks into the free web tool and every changed cell, formula, and sheet is laid out side by side — it runs in your browser, so nothing is uploaded. For a team, the hosted platform watches the OneDrive or SharePoint library you already use, compares each new version automatically, and keeps an exportable record of who changed what, when — the audit trail Show Changes can’t give you.

Frequently asked questions

Where did Track Changes go in Excel?
It’s still in there, just hidden. The classic Track Changes (Highlight Changes) belongs to the old “Shared Workbook” feature, which Microsoft replaced with co-authoring. The buttons are removed from the ribbon by default; you can surface them again from File → Options → Quick Access Toolbar by adding the legacy Track Changes commands. Microsoft now points people toward Show Changes for files in OneDrive or SharePoint.
What is “Show Changes” in Excel?
Show Changes (Review → Show Changes) is the modern replacement. For a workbook stored in OneDrive or SharePoint and edited online or in a current desktop build, it opens a pane listing recent cell edits — what changed, who changed it, and when. It’s handy for catching a recent edit, but it shows a feed of edits, not a comparison of two versions or two files you choose.
Can I track changes between two completely separate files?
Not with Excel’s built-in features — both Track Changes and Show Changes work inside one workbook’s own edit history. To compare two separate files, like budget_v2.xlsx against budget_v3.xlsx, you need a compare tool. SheetDelta does exactly that: drop in two files and see every changed cell, formula, and sheet. See compare Excel files.
Does Show Changes tell me when a formula changed?
It records that a cell’s value changed, but it isn’t built to highlight when a formula was edited or when a formula was replaced by a typed-in number — one of the changes most likely to quietly break a model. SheetDelta compares formulas as logic, so a formula that became a hard-coded value shows up clearly.
How far back do Excel’s change features go?
Show Changes focuses on recent edits and depends on the file living in OneDrive or SharePoint; older edits age out of the view. SheetDelta keeps a parallel history you can compare between any two versions, with retention you control and an export you can hand to an auditor. See Excel version history.

Keep reading

Excel version history →

Roll a file back vs see what changed inside it.
Compare Excel files →

Drop in two workbooks and see every change, free.
Excel audit trail →

A provable, exportable record of who changed what.
Excel version control →

History, review, and sign-off for a team.
Compare two Excel sheets →

Every method, from formulas to one click.
VBA diff →

See macro changes Show Changes never touches.

See every change, not just the recent ones

Compare any two versions or two files — formulas, structure, and macros included — in your browser or across your team.

Compare two files now Explore the platform