Track Changes in a Shared Workbook See Who Edited What and When
'Who changed this rate?' is the question that starts office arguments — and in a properly configured shared workbook, it ends them in thirty seconds. The file itself remembers every change. This page shows how to make sure it remembers, how to read the record, and where the record's honesty runs out.
✍️ Technical Anshu🪟 Windows 10 / 11⏱️ 8 minute read
🎥 Watch the full video — offline Excel collaboration set up step by step on a local network
A shared workbook quietly keeps a diary. Every time someone saves, Excel writes down who made each change, when, which cell, and the old and new values. That diary — the change history — is the feature that turns shared editing from an act of faith into something a manager can actually supervise. It is also a feature with settings that decide whether the diary exists at all, how long it remembers, and how trustworthy the names in it are. All three deserve ten minutes of attention before your team depends on it.
A change history sheet — what the diary actually records
Date and time24 Oct 2026, 11:42 AM
WhoRamesh — from his Excel user name
ActionCell change
WhereStock sheet, cell D18
Old value → New value450 → 425
A second change to the same cell laterListed as its own row — nothing overwritten
Example entries in the real layout of Excel's history sheet. Every change is a row, so a cell edited five times tells its whole story in five rows.
1
Switch the Diary On — and Set Its Memory
Change tracking arrives with sharing, but its retention setting is yours to choose, and the default quietly forgets.
Open Review > Share Workbook > Advanced and find Track changes — Keep change history for — the default is 30 days
Set the retention to cover your real checking cycle — a monthly-reconciled register wants 60 to 90 days, accepting a larger file as the price
The alternative, Don't keep change history, disables the diary entirely — never select it on a file the team depends on
Remember that changes older than the retention window are dropped at the next save — history is a rolling window, not an archive
2
Read the Diary — Highlight and the History Sheet
Two views answer two different questions: what changed in the area I am looking at, and everything that happened in order.
For a quick look: Review > Track Changes (Legacy) > Highlight Changes — changed cells get a marker, and hovering shows who, when and the previous value
For the full record: in the same dialog, tick List changes on a new sheet — Excel builds a History sheet with one row per change
Filter the dialog by When, Who and Where to answer precise questions — 'everything Priya touched in the Rates sheet this week'
Add the Track Changes button to your ribbon or Quick Access Toolbar once, through Options and All Commands, if it is hidden
3
Accept or Reject — Undoing Someone's Edit Properly
The diary is not only for reading. Through Review > Track Changes > Accept or Reject Changes, a reviewer walks the recorded changes and approves or reverses each one, restoring the old value on a reject. This is the controlled way to unwind a wrong entry without hand-editing over it — the rejection itself becomes part of the record, so the correction is as visible as the mistake.
4
The Honest Limits of the Diary
Trust the change history as a working tool, not as courtroom evidence.
Names are self-declared: the diary records the user name typed in each Excel's options — set every PC to its real user's name on day one, or the diary fills with 'Admin' and 'User'
It can be switched off: anyone who can unshare the workbook can end the history; protect sharing with a password through Protect Shared Workbook so the setting survives enthusiasm
It is not tamper-proof: a determined person with file access can do many things outside Excel's sight — for money-critical records, the diary supervises honest staff, it does not defeat a fraudster
Formatting and deletions of rows of history are recorded more thinly than cell value changes — check the entries that matter rather than assuming everything is equally visible
🔴 Set the names before you need the names. The day a rate is disputed, it is too late to discover every PC in the office calls itself 'User'. Ten minutes spent setting real user names in Excel on each machine is what makes the change history worth having.
🎥 Watch Shared Editing and Merging in Action
The video shows several users working in one workbook — the changes being recorded there are exactly the diary this page teaches you to read.
Why does the history show every change under the same name
Because Excel takes the name from each installation's user name setting, and most PCs ship with it set to a generic word or the Windows account label. Fix it per machine under File, Options, General, User name — type the person's real name. Changes already recorded keep their old labels; only new changes pick up the corrected name.
How long does Excel keep the change history
As long as the retention period set in Share Workbook's Advanced tab — 30 days by default, adjustable up or down. Each save prunes changes older than that window. If your reconciliation cycle is monthly, set retention comfortably beyond it, and accept the side effect: a longer history makes the workbook file larger and a little slower to save.
Can someone edit the file without the change being recorded
Within normal shared use through Excel, no — value changes are recorded as part of how shared mode works. The gaps are at the edges: someone with the password can unshare the workbook, which ends recording, and edits made to a copied file happen entirely outside the diary. That is why Protect Shared Workbook exists and why the master file should live in only one place.
This guide follows the offline Excel collaboration method in the Technical Anshu video above • Stuck on a step? Ask in the video comments and the community will help 🙏