Spreadsheets

Restore an earlier version of an Excel file from OneDrive

Restore an earlier version of an Excel file from OneDrive: open Version History from the file name menu, then preview, restore or save a copy.

Editorial illustration for Restore an earlier version of an Excel file from OneDrive

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?

  1. Open the workbook from OneDrive, not from a downloaded copy.
  2. Click the file name in the title bar at the top of Excel.
  3. Choose Version History from the menu.
  4. 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.

ChoiceWhat it doesWhen to use it
RestoreReplaces the live file with that older versionYou are sure the whole file should go back
Save a copyCreates a separate file from that version and leaves the live one aloneYou 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?

CauseWhat to check
The file is saved on your computer, not OneDriveLook at the title bar for a cloud location; save the file to OneDrive
The file is open from an email attachmentSave it to OneDrive first, then reopen
Your version of Excel is olderLook under File > Info, or use the OneDrive website instead
You only have view accessAsk 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

  1. Before a big edit, save a copy named with the date.
  2. At the end of each month, save a copy to a different folder.
  3. At the financial year end, in March, keep a read-only copy of the final file.
  4. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports