If your Excel file is saved in OneDrive, click the file name at the top of the window and choose Version History. A panel lists earlier versions. Open one to preview it, then restore it or save a copy. Files saved only on your own computer do not have this history, so you may have to rely on other recovery options.
How do I open Version History in Excel?
- Open the workbook from OneDrive, not from a downloaded copy.
- Click the file name in the title bar at the top of Excel.
- Choose Version History from the menu.
- A panel opens with versions listed by date and time, newest first.
Another route is File > Info > Version History in the desktop app, and in a browser you can right-click the file in OneDrive and look for Version history. The labels differ between versions, so look for the nearest wording.
How do I restore or save a copy?
Click a version in the list. It opens in a separate window, marked as a previous version, so you can look through it without touching your live file.
| Choice | What it does | When to use it |
|---|---|---|
| Restore | Replaces the live file with that older version | You are sure the whole file should go back |
| Save a copy | Creates a separate file from that version and leaves the live one alone | You want to compare, or rescue one tab or a block of cells |
What does AutoSave change?
With AutoSave switched on for a file in OneDrive, Excel saves your changes as you make them. That is helpful for sharing, but it also means a mistake is saved at once. There is no close-without-saving escape. Version History is the safety net: each saved state is a point you may be able to go back to.
- If you are about to try a large change, such as deleting columns or pasting over formulas, use File > Save a Copy first, or turn AutoSave off for that session.
- Undo (Ctrl+Z) still works for recent actions in the open session, so try it first for a small slip.
- If you close the file and then notice a problem, use Version History instead.
Why do I not see Version History?
| Cause | What to check |
|---|---|
| The file is saved on your computer, not OneDrive | Look at the title bar for a cloud location; save the file to OneDrive |
| The file is open from an email attachment | Save it to OneDrive first, then reopen |
| Your version of Excel is older | Look under File > Info, or use the OneDrive website instead |
| You only have view access | Ask the owner to give you edit access or to restore it |
A file that has lived only on a laptop is not versioned like this. For those, try the AutoRecover options in File > Info for unsaved changes, or look in the Recycle Bin if the file was deleted. If you have never moved the file to the cloud, consider doing so and keeping a second copy elsewhere.
What if the file was deleted or overwritten?
In OneDrive on the web, open the Recycle bin and restore the file if it was deleted. If it was overwritten with a different file of the same name, open the file's version history from the website and look for the older version. Do not rely on versions being kept forever, since a storage limit or a retention rule can remove old ones. Act soon after you notice.
A quick habit that helps
- Before a big edit, save a copy named with the date.
- At the end of each month, save a copy to a different folder.
- At the financial year end, in March, keep a read-only copy of the final file.
- Once a year, try restoring a version to a copy, to be sure you know how.
These steps protect a spreadsheet. If you want a record that keeps deleted transactions for 30 days and holds each one against its account, SpendixAI offers a recycle bin and reports, alongside statement imports in PDF, CSV or Excel.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

