If you’ve ever made a few minor mistakes and saved an Excel workbook, you know that sometimes it takes a long time to undo that mistake. We’ll show you how to view and restore previous versions of Microsoft Excel workbooks.
Before we get started, you should know that a Microsoft 365 subscription is required to access version history in Excel. If you have this subscription, you get the full Office suite along with OneDrive cloud storage.
You need to set up OneDrive on your computer by opening the app and logging in. Once this is done, save any Excel document to OneDrive and from then on you will have access to the full version history. Any edits you make from now on will be logged, and Excel makes it very easy to revert to a previously saved version of the workbook.
First, open Microsoft Excel and go to one of your workbooks. Double-check that the Autosave switch at the top is turned on, and if not, save the document to OneDrive to turn it on.
Make as many changes to this document as you want. When you’re done, click on the file name in the top bar.
Select ‘Version History’.
You can also click the “File” button at the top.
Select “Info” in the left pane.
Click on ‘Version History’.
Both methods yield the same end result. Excel opens a Version History pane that appears on the right. Here you will see multiple saved versions of your workbook, along with the date and a timestamp.
Once you’ve selected which version of your workbook you want to open, click “Open Version.”
This will open a read-only workbook and you can go through it to make sure it’s the correct version. If so, click ‘Restore’.
Reverts to the old version of the Microsoft Excel workbook. You can also review how to prevent workbooks from being edited in Microsoft Excel.
RELATED: Protect workbooks, worksheets, and cells from editing in Microsoft Excel