Excel Version History: What It Restores, and What It Won't Tell You
An independent product, not affiliated with Microsoft.
Excel version history is a OneDrive and SharePoint feature that saves a snapshot of the whole workbook every time it's saved, and lets you open, compare, or restore any earlier one. It's built into Microsoft 365 at no extra cost, and there's nothing to turn on. It also has real limits that catch people off guard: it only works on files stored in the cloud, Microsoft doesn't publish one fixed retention window, and a restored version never tells you why a number changed, only that it did.
What is Excel version history?
Version History keeps a copy of the entire file each time it's saved to OneDrive or SharePoint, whether you save manually or AutoSave does it in the background. Each saved copy becomes a version in a list you can open read-only, compare with the current file, restore as the new current version, or download separately. It preserves the whole file, not a log of individual edits, that's a different, newer feature called Show Changes, which lists per-cell edits instead of whole-file snapshots.
How do I view or restore a previous version in Excel?
- Make sure the workbook is saved to OneDrive or SharePoint. Version History doesn't exist for a purely local file.
- In Excel, go to File → Info → Version History, or click the file name in the title bar and choose Version History.
- In a browser, right-click the file at onedrive.com or in a SharePoint library and pick Version History instead.
- Open any entry to inspect it read-only, then Restore to make it the current version, or download a copy if you just want to compare without disturbing the live file.
What does version history do well?
Because each version is the entire file, it captures everything a cell-level log can't: charts, PivotTables, conditional formatting, and macros are all present in an old version exactly as they were, since it's a full snapshot, not a diff. It runs automatically for any cloud-stored workbook with no setup, restoring in place takes one click, and it works alongside real-time co-authoring on the same file.
What are Excel version history's documented limits?
The whole-file model that makes version history useful is also what limits it. The table below separates what Microsoft actually documents from what it doesn't.
| What matters | Excel Version History | ExcelRewind |
|---|---|---|
| Requires OneDrive or SharePoint | Yes — a local-only file has no version history | No, works on any file, any storage location |
| Retention window Microsoft documents | Last 25 versions on a personal account; work/school accounts depend on library and retention settings, no fixed day-count published (a ~60-day figure is a third-party estimate) | No fixed cap — the recording is a file you keep |
| Captures charts, formatting, macros | Present in each whole-file snapshot, but not tracked as a discrete change | No, also cell-focused |
| Survives deleting and re-uploading the file | No — a new upload starts a new version chain | Yes, the .rewind file is independent of the live workbook |
| Exportable or shareable outside the file's home | No — the history lives inside OneDrive/SharePoint only | Yes, a portable .rewind file |
| Records why a value changed | No | Yes (a note per edit) |
Every Excel-side row reflects documented or well-understood platform behavior. Version history is a genuinely useful restore point; it was never built to explain a change, only to let you undo one.
Version history vs. Show Changes: what's the difference?
Version History restores a whole prior file. Show Changes lists individual cell edits, who changed what, the old and new value, and when, for up to 60 days per Microsoft's own documentation on that specific feature. Neither one records the reasoning behind an edit. For the full walkthrough of Show Changes and the legacy Track Changes feature, see how to track changes in Excel; for a side-by-side against ExcelRewind, see ExcelRewind vs Excel Track Changes.
What does a .rewind replay add?
This is the gap neither feature closes. ExcelRewind is an Excel add-in (with a Google Sheets add-on) that records why the numbers in a spreadsheet change. It captures every cell edit with timing and a note explaining the reasoning, and saves them to a shareable, replayable .rewind companion file. It never modifies the original workbook and never uploads spreadsheet content1. Because it writes a separate companion file instead of relying on cloud storage, it works on a workbook regardless of where it's saved, and the recording doesn't depend on OneDrive or SharePoint retention settings at all.
See a real recording replay in your browser. You don't need an account or an install.
Watch a live replayInstall the add-in or see how a .rewind file is put together.
Frequently asked questions
How do I show changes in Excel?
Open the workbook from OneDrive or SharePoint in Excel for the web or a current Microsoft 365 app, then go to the Review tab and select Show Changes. A pane opens listing who changed each cell, the old and new value, and when, and you can filter it by sheet, range, or person. It only works on that specific combination, cloud-stored file plus a supported app; a locally saved copy or an older desktop build won't show anything there.
How do I enable track changes in Excel?
There's nothing to enable for the modern Show Changes feature: if the workbook is on OneDrive or SharePoint, open Review → Show Changes and it's already logging. The classic Track Changes feature, tied to Shared Workbooks, is different and genuinely hidden by default: add it via File → Options → Quick Access Toolbar → All Commands, add "Track Changes (Legacy)", then use Highlight Changes to turn it on for that file. Microsoft has deprecated it in favor of co-authoring and Show Changes, so treat it as a fallback for offline, locally saved files only.
How do I view Excel version history?
Save the workbook to OneDrive or SharePoint, then in Excel go to File → Info → Version History, or click the file name in the title bar and choose Version History. In a browser, right-click the file at onedrive.com or in a SharePoint library and pick Version History. Each entry opens read-only so you can compare it with the current file, restore it as the new current version, or download a separate copy without touching the live file.
How long does Excel keep version history?
Microsoft doesn't publish one fixed retention window for OneDrive or SharePoint version history. What it does document: a personal Microsoft account can retrieve the last 25 versions of a file, and for work or school accounts how far back you can go depends on your organization's library and retention settings, an admin can also disable versioning entirely. A roughly 60-day figure shows up in third-party trackers and community threads, but that number isn't in Microsoft's own documentation, so treat it as a rule of thumb, not a guarantee.
Does Excel version history explain why a value changed?
No. A restored version shows you an earlier state of the whole file, and Show Changes shows the old and new value of a cell, but neither records the reasoning behind an edit. ExcelRewind is an Excel add-in that records every cell edit with timing and a note explaining why it changed, saved to a shareable, replayable .rewind file. It never modifies the original workbook and never uploads spreadsheet content, with one exception: a Kiosk/Exam mode submission uploads the finished recording for instructor review (sealed to the organization's encryption key when one is enabled).
1 The one exception: a Kiosk/Exam mode submission uploads the finished exam recording to ExcelRewind's storage for instructor review, sealed to the organization's encryption key when one is enabled.
Last updated: August 2026.
ExcelRewind is an independent product and is not affiliated with, endorsed by, or sponsored by Microsoft Corporation. Microsoft and Excel are trademarks of the Microsoft group of companies. Questions? [email protected].