Microsoft Excel logo

If you’ve ever made a couple of minor mistakes and saved an Excel workbook, you’ll know that it sometimes takes a long time to undo that error. 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 necessary to access version history on Excel. If you have this subscription, you get the entire Office suite along with OneDrive cloud storage.

You’ll need to set up OneDrive on your computer by opening the app and logging in. Once this is done, just save any Excel document in OneDrive, and from that moment on, you’ll be able to access its entire version history. Any edits that you make from here on out will be logged, and Excel makes it really easy to go back to any previously saved version of the workbook.

First, open Microsoft Excel and go to any of your workbooks. Double-check that the AutoSave toggle at the top is on, and if it isn’t, just save the document in OneDrive to enable it.

Make sure AutoSave is on

Make as many edits to this document as you wish to. Once you’re done, click the file name in the top bar.

Click the file name

Select “Version History.”

Click Version History

Advertisement

Alternatively, you can click the “File” button at the top.

Click File

Select “Info” in the left pane.

Click Info

Click “Version History.”

Click Version History

Both methods will deliver the same end result—Excel will open a Version History pane that will appear on the right. Here, you’ll see multiple saved versions of your workbook, along with the date and a time stamp.

The Version History pane in Excel

Once you’ve selected which version of your workbook you want to open, click “Open Version.”

Click open version

This will open up a read-only workbook, and you can go through it to check whether it’s the correct version. If it is, click “Restore.”

Click Restore

This will bring back the old version of the Microsoft Excel workbook. You can also check out how to protect workbooks from being edited in Microsoft Excel.

RELATED: How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel

Pranay Parab Pranay Parab
Pranay Parab has been a technology journalist for over 10 years, during which time he's written well over 500 tutorials, and covered everything from social media apps to enterprise software. Pranay lives in Mumbai, India, and is currently pursuing an MBA.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.