Excel Workbook History: View, Compare, and Restore Versions

To view Excel workbook history, open a workbook saved in OneDrive or SharePoint and choose File > Info > Version History in Excel for Microsoft 365 on Windows. You can open an earlier saved version and, if appropriate, restore it; a workbook saved only on your computer does not automatically contain a complete history of its past versions.

What Excel workbook history means

People use “workbook history” to mean two related but different things: saved versions of a file, and a record of edits made to cells. Excel provides both in some situations, but they are not the same feature. Version History lets you retrieve an earlier saved state of a workbook. Show Changes can display a recent record of changes to cells, including who made a change and when, when that information is available.

Neither feature is a permanent, exhaustive log embedded in every Excel file. Version history depends on the workbook’s storage location and the cloud service’s retention settings. Change details also have limits. If you need dependable records for an important workbook, plan where it is stored, who can edit it, and how long records must be kept.

Where version history is available

Excel’s built-in Version History is designed for files saved to OneDrive or SharePoint. These services keep earlier file states so that you can return to a previous version after an unwanted edit, deletion, or other problem. A work or school account may have retention policies set by its Microsoft 365 administrator, so the number of available versions and how long they remain can vary.

For a workbook stored on your computer, a USB drive, or a network location, Excel does not usually create a browsable sequence of saved versions. AutoRecover may help with an unsaved or unexpectedly closed workbook, but it is not a substitute for version history. Windows backup tools or an organization’s backup system may retain file copies, but those are separate from Excel’s cloud Version History.

AutoSave and version history are connected to cloud storage, but they do different jobs. AutoSave saves ongoing changes to a supported OneDrive or SharePoint file. Version History gives you access to earlier saved states. Turning AutoSave off does not turn a local file into a versioned file, and saving a file in the cloud does not mean that every individual keystroke becomes a separately restorable version.

How to view earlier versions in Excel

In Excel for Microsoft 365 on Windows, open the cloud-stored workbook, then select File > Info > Version History. A Version History pane lists available saved versions, usually with dates and times. Select a version to open or inspect it. Depending on your Excel build and account, you may also be able to open the history from the workbook name or title-bar controls.

Confirm that the workbook is saved in OneDrive or SharePoint and that you are signed in to the account that can access it.
Open the workbook in Excel and choose File > Info > Version History.
Select a dated version to inspect its contents. If you are unsure which one is right, compare it with the current workbook before restoring anything.
Use Restore only when you want the selected earlier state to become the current version.

In Excel for the web, you can usually find the file in OneDrive or SharePoint, open its context menu, and choose Version history. The exact menu placement can vary with the site layout. In Excel for Mac, the version-history command may appear as File > Browse Version History; availability depends on the Microsoft 365 build and where the file is stored. If you cannot find the command, check the file in OneDrive or SharePoint online instead.

Restore, inspect, or compare a version

Opening an older version is safer than immediately restoring it: you can verify that it contains the figures, formulas, worksheets, or formatting you need. Restoring makes the selected version the current state of the workbook. The cloud service generally records the resulting change as a newer version, but the exact history and retention behavior can depend on OneDrive or SharePoint settings. Do not assume that every organization keeps every version indefinitely.

If you want to keep both states, make a separate copy before restoring, or open the old version and save a copy with a different name if that option is available. To compare two versions, inspect them side by side or copy relevant sheets or ranges into a separate comparison workbook. Excel’s Version History is principally a way to access saved file states; it does not provide a universal, detailed, side-by-side report of every difference between two complete workbooks.

For a shared budget, for example, suppose someone overwrites a formula in the monthly totals column. An earlier version may let you recover the formula and the surrounding workbook state. Before restoring the entire file, check whether colleagues have entered valid transactions since that version was saved. A full restore could replace those newer entries too. When only a few cells are wrong, it may be safer to copy the needed cells or formula from the earlier version into the current workbook.

Show Changes is not the same as Version History

Show Changes is useful when the question is “Who changed this cell?” rather than “What did the whole file look like yesterday?” In supported Microsoft 365 workbooks, choose Review > Show Changes to open a pane showing recent cell edits, such as changed values or formulas, along with the editor and time when available. Select an entry to see the affected cell and, in supported cases, its previous value.

Show Changes is not a complete audit trail of every workbook action. It focuses on supported cell changes; it is not designed to reconstruct every formatting adjustment, structural change, or action in every Excel feature. Microsoft documents a history window of up to 60 days for Show Changes, but the useful details available can depend on the workbook and the type of edit. Treat it as a convenient review tool, not as a compliance archive or a replacement for backups.

For collaboration, supported modern Excel files can be coauthored by multiple people, with changes saved through OneDrive or SharePoint. Coauthoring describes how people work in the same file; Show Changes describes certain edits; Version History preserves earlier saved states. These related cloud features answer different questions.

What if the workbook is stored locally?

If a local workbook was saved over by mistake, first check whether you have a backup: Windows File History, a company backup service, a synchronized folder’s own history, or another copy may provide one. Windows’ Previous Versions tab is useful only when an appropriate backup or restore point has been configured. Excel cannot recreate old saved contents that were never retained somewhere.

For a workbook that was never saved or closed unexpectedly, try Excel’s recovery options. In Excel for Microsoft 365 on Windows, look under File > Info > Manage Workbook for Recover Unsaved Workbooks, when available. You can also check the Document Recovery pane that may appear when Excel restarts after a crash. Recovered files may be incomplete or older than the last edits, so verify key data before relying on them.

To improve protection for future work, save important shared workbooks to an approved OneDrive or SharePoint location, confirm that syncing has finished, and keep a separate backup when required. For a local-only workflow, create dated copies or use an established backup system. A filename such as QuarterlyBudget_2026-11-02.xlsx can help distinguish copies, though manual naming alone is not a managed history system.

Common problems and misconceptions

No Version History command: The workbook may be local, you may be signed into the wrong account, or you may lack access to its cloud location. Check the file’s location and open it from OneDrive or SharePoint.
The version list looks incomplete: Available history depends on the service, account, administrator policies, and retention. There is no universal number of versions guaranteed for every workbook.
A restore removes newer work: Restoring an earlier whole-file state can replace later edits. Inspect the old version and preserve a copy before restoring if recent work matters.
Undo is not history: Ctrl+Z on Windows (Command+Z on Mac) reverses recent actions in the current editing session where supported. It is not a durable record of saved versions and may not help after the workbook is closed.
AutoRecover is not a version archive: It can help recover unsaved work, but it does not promise a browsable history of every saved edit.

Another common assumption is that a workbook carries its own complete edit log when it is emailed or copied to a USB drive. In general, the file contains its current workbook contents, not a full timeline of every previous saved state. If you download or copy a file away from its cloud service, the original cloud history may remain with the cloud copy rather than travel with the downloaded file.

Frequently Asked Questions

Can I see who edited an Excel workbook?
For a supported workbook stored in OneDrive or SharePoint, open Review > Show Changes to see available recent cell-edit details. Version History can show saved versions and their dates, but it is not necessarily a complete list of every person’s actions.

Can I recover an Excel file I saved over?
If it was stored in OneDrive or SharePoint, check Version History for an earlier state. If it was local, look for a backup or a copy. Excel’s recovery features may help with unsaved work after a crash, but cannot guarantee recovery of an overwritten local file.

How far back does Excel version history go?
There is no single answer for every account. OneDrive or SharePoint retention settings, available storage, and organizational policies affect which versions remain. Show Changes has a separate history window of up to 60 days in supported Microsoft 365 scenarios.

Can I view workbook history in Excel for the web?
Yes, for files stored in OneDrive or SharePoint. Open the file’s menu in the storage service and choose Version history. You can also use supported history commands in Excel, depending on the interface and account.

Does Excel keep a history of every formula change?
No. Version History preserves earlier file states when supported, while Show Changes reports certain recent cell edits. Neither should be treated as a guaranteed permanent record of every formula change or workbook action.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.