If you’ve ever designed a few of minor problems and saved an Excel workbook, you will know that it often requires a extended time to undo that mistake. We’ll exhibit you how to look at and restore preceding versions of Microsoft Excel workbooks.
Just before we get started, you should know that a Microsoft 365 membership is needed to accessibility version history on Excel. If you have this membership, you get the total Business suite together with OneDrive cloud storage.
You’ll need to have to set up OneDrive on your laptop by opening the app and logging in. After this is completed, just help you save any Excel document in OneDrive, and from that instant on, you will be in a position to obtain its overall variation heritage. Any edits that you make from right here on out will be logged, and Excel makes it genuinely simple to go back again to any beforehand saved model of the workbook.
1st, open Microsoft Excel and go to any of your workbooks. Double-check out that the AutoSave toggle at the prime is on, and if it is not, just help save the document in OneDrive to allow it.
Make as many edits to this doc as you want to. As soon as you’re completed, click the file identify in the prime bar.
Decide on “Version Historical past.”
Alternatively, you can click the “File” button at the best.
Find “Info” in the remaining pane.
Simply click “Version Heritage.”
Both of those approaches will produce the same conclusion result—Excel will open up a Variation History pane that will look on the correct. Here, you are going to see multiple saved variations of your workbook, along with the date and a time stamp.
When you have picked which model of your workbook you want to open, click on “Open Edition.”
This will open up a examine-only workbook, and you can go through it to check irrespective of whether it’s the right model. If it is, click on “Restore.”
This will convey again the outdated edition of the Microsoft Excel workbook. You can also look at out how to safeguard workbooks from getting edited in Microsoft Excel.
Related: How to Secure Workbooks, Worksheets, and Cells From Editing in Microsoft Excel