To check save history in Excel for Microsoft 365 on Windows, open the workbook and select File > Info > Version History. You can review earlier saved versions and, if needed, open or restore one. This history is generally available when the workbook is stored in OneDrive or SharePoint; a file saved only on your computer usually does not have a browsable version history.
What You’ll Need
- The workbook you want to check, opened in Excel for Microsoft 365.
- For version history, a workbook saved in OneDrive or SharePoint, plus access to that location. You may need to sign in with the Microsoft account or work or school account that has permission to the file.
- If you plan to restore an older version, consider making a separate copy of the current workbook first. Restoring changes the current contents, so a backup gives you a way back if you choose the wrong version.
Step-by-Step
- Open the correct workbook. In Excel, check the workbook name at the top of the window. If you have similarly named files, confirm the location too: select File > Info and look at the file location, or check the folder shown in the Open screen. Version history belongs to a particular cloud file, not just to a workbook name.
- Check that the file is stored in OneDrive or SharePoint. Select File > Info. The location or file details should indicate OneDrive or a SharePoint site. If you opened the workbook from a local folder such as Documents or Downloads, it may not have cloud version history. A cloud icon or AutoSave switch can be a clue, but confirm the location rather than relying on the icon alone.
- Open the version history. In Excel for Microsoft 365 on Windows, select File > Info > Version History. Excel opens a Version History pane, usually on the right, with available saved versions and their dates and times. In some builds, you may also be able to select the workbook name in the title bar and choose Version History. If the command is missing, check the Troubleshooting section below.
- Review the versions in the list. Select a timestamp to inspect a particular saved version. The details shown can include who saved it and when. Availability and labels vary with the storage service, your permissions, and the Excel build. The list represents versions retained by OneDrive or SharePoint; it is not necessarily a record of every keystroke or every individual cell edit.
- Open a version before deciding what to do. Choose the option to open or view the selected version, if offered. Excel may open it as a separate, read-only workbook. Check the worksheets, formulas, and data that matter, and compare them with the current workbook. Do not assume the newest timestamp is automatically the version you want; find the last version that contains the information you need.
- Restore only when you mean to replace the current contents. If you decide an earlier version should become the current one, select Restore for that version and read any confirmation prompt. Restoring is different from simply opening a version: it changes the current workbook. Before you confirm, make a copy of the current file if you may need its latest edits. After restoring, check the workbook and confirm the expected data is present.
- Use a copy when you only need to retrieve a few items. If you want one deleted sheet, formula, or range rather than a full rollback, open the older version and copy the needed content into a separate copy of the current workbook. Check formulas and references after pasting, since they may point to other sheets or files. This avoids replacing unrelated recent work.
- Save and verify your result. After editing a copy or continuing from the restored version, save it to the intended location. Check the workbook name and location again so you do not accidentally overwrite a different file. If the file is shared, let collaborators know about a restore or significant recovery so they can confirm their latest edits are accounted for.
For Excel for the web: Open the workbook from OneDrive or SharePoint, then use File > Info > Version History when that command is available. You can also locate the file in OneDrive or the SharePoint document library, open its file menu, and choose Version history. The exact placement can differ by the site layout. Select a version to view or restore it; take care to distinguish viewing from restoring.
For Excel for Mac: In supported Microsoft 365 builds, open the cloud workbook and look under File > Browse Version History. The wording and interface can vary by build. If the option is unavailable, check the file in OneDrive or SharePoint in a browser, where the file’s version history may still be accessible. A workbook saved only on the Mac does not gain cloud version history just because Excel is installed.
Common Mistakes
- Looking for a history on a local-only file. Excel does not normally keep a browsable series of saved versions for every workbook on your hard drive. AutoRecover and temporary recovery files are not the same as OneDrive or SharePoint version history.
- Treating AutoSave as a version list. AutoSave can save changes to a cloud workbook as you work, but the switch itself does not show earlier versions. Use Version History to find versions retained by the cloud service.
- Restoring before checking the selected version. A restore can replace recent contents across the workbook, not just the cell you are investigating. Open and inspect a version first, and make a copy of the current workbook if there is any doubt.
- Assuming a timestamp explains every change. Version history shows saved snapshots, not necessarily a complete activity log. It may not identify every edit or show the old and new value for each cell.
- Confusing workbook history with Show Changes. Version History helps you open or restore saved versions. For cell-level edits in supported Microsoft 365 workbooks, use Review > Show Changes if available. Show Changes has its own limits and is not a replacement for keeping backups.
- Checking the wrong copy. A downloaded attachment, emailed copy, or workbook saved under another name can have a separate history—or none. Confirm the file path and cloud location before drawing conclusions.
Tips
- Keep important work in OneDrive or SharePoint. Saving or moving a workbook to an approved cloud location is the practical way to make cloud version history available going forward. Follow your organization’s storage rules for work files.
- Use clear file names for major milestones. Version history is useful for recovery, while a separate named copy can make a major handoff or milestone easier to recognize. Avoid creating confusing copies with identical names in different folders.
- Use Show Changes for a different question. If you need to know who changed a particular cell and what it changed from, select Review > Show Changes in supported Excel for Microsoft 365 workbooks. The pane can show details such as the cell, editor, time, and prior value. Its history is limited, and it may not capture every kind of change.
- Make a copy before experimenting. If the workbook is important or shared, use File > Save As to save a separate copy before restoring or testing changes. Check the destination carefully so the copy does not overwrite the original.
- Check the right account. Personal OneDrive and work or school OneDrive are separate locations. If Excel is signed into the wrong account, the workbook may open but show different access or history options than expected.
- Know what history cannot do. If a file was never stored in a versioned cloud location, moving it to OneDrive now does not recreate its past saves. It can begin accumulating versions after it is saved there, subject to the service’s retention and settings.
Troubleshooting
Version History is missing or disabled: First confirm the workbook is saved in OneDrive or SharePoint, not merely opened from a local folder or email attachment. Then sign in to the account that owns or has access to the file and check that you have permission to view it. If the file is in a work or school library, an administrator’s settings or retention policy may affect versioning. Try opening the file from its OneDrive or SharePoint location in a browser. If the command remains unavailable, ask the file owner or administrator whether version history is enabled for that library.
The list appears empty or has only a few entries: Check that you are viewing the original cloud file rather than a downloaded or copied version. Version history may have started only after the file was stored in the cloud, and older entries can be removed under retention rules. The number of versions shown is not guaranteed to match the number of times someone saved the workbook.
The old version will not open: Check your internet connection and make sure you still have permission to the file. Close other copies of the workbook and try again from OneDrive or SharePoint in a browser. If the version is available there but Excel cannot open it, download or open a copy through the browser options, if offered, rather than restoring immediately.
You restored a version but cannot find the newer edits: Do not continue making changes until you know which copy is current. Reopen Version History and look for the version that was current before the restore; restoring commonly creates a new current version while retaining earlier versions, but behavior can depend on the service and permissions. Open the relevant version and copy any needed content into a separate file. If the expected version is absent, contact the file owner or administrator promptly.
You need to recover unsaved work rather than an earlier save: Version History only helps with versions that were saved to the cloud. In Excel for Windows, check File > Info > Manage Workbook for available recovery options, such as recovering unsaved workbooks. The options shown depend on whether Excel created a recovery copy. AutoRecover is not a guaranteed substitute for saving, and a recovered file may not contain the latest changes.
Frequently Asked Questions
Can I see the save history of an Excel file saved only on my computer?
Usually not as a list of prior saved versions in Excel. Check for a backup, File History, or another backup service, but those are separate from Excel’s cloud Version History. AutoRecover may help with unsaved work, not provide a full save-by-save timeline.
Does Excel show who changed each cell?
Version History can identify saved versions and may show who saved them, but it is not a detailed cell audit. For supported Microsoft 365 files, try Review > Show Changes to inspect recorded edits. Not every change or older edit is necessarily available there.
Can I check version history without restoring an older version?
Yes. Select a version and open or view it to inspect the contents. Restore only if you want that older state to become the current workbook. If you just need a few cells or a sheet, copy them from the old version into a separate current copy.
Does AutoSave keep every edit forever?
No. AutoSave helps save changes to supported cloud files, but it does not promise an unlimited permanent record of every edit. The versions available depend on OneDrive or SharePoint retention and versioning settings.
Why does version history look different on my Mac or in a browser?
Excel’s menus vary by platform and build. On Mac, look for File > Browse Version History; in a browser, use Excel’s File menu or the file menu in OneDrive or SharePoint. If a command is absent, check the cloud file’s menu and confirm you are signed in with the right account.
Can I recover a file I deleted?
Version History is for versions of a file that still exists. If the workbook itself was deleted, check the OneDrive or SharePoint recycle bin and your organization’s recovery options. A site administrator may be able to help if the file is not in your recycle bin.
Related
- Change Table Color in Excel: Styles and Custom Formatting
- Excel Subscript: How to Change Text to Subscript
- How to Change Strikethrough Color in Excel Cells Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Page Break Lines Won’t Go Away? How to Hide ThemTo hide page-break lines in Excel for Microsoft 365 on Windows, switch to View > Normal, then go…
- How to Combine Multiple Excel Files with Power QueryThe easiest way to combine multiple Excel files in Microsoft 365 on Windows is Power Query: put the…
- COUNTIF Text in Google Sheets: Examples and TipsTo count text in Google Sheets, use COUNTIF with the cells to check and the text criterion, such…
- Protect a Sheet in Excel From Viewing: What Actually WorksTo keep a worksheet out of casual view in Excel for Microsoft 365 on Windows, hide its tab,…
- Leading Zeros in Excel: How to Keep ThemTo keep a leading zero in Excel, store the entry as text or apply a custom number format…
- Excel Merge Cells Without Merging: Better AlternativesTo make cells look merged without actually merging them in Excel, select the range, open Format Cells with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.