Retrieve Past Excel Workbook Versions Easily and Securely

Retrieve Past Excel Workbook Versions Easily and Securely

Paul Lv12

Retrieve Past Excel Workbook Versions Easily and Securely

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.

Related: All the Best Microsoft Excel Keyboard Shortcuts

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

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.

Click Version History

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

  • Title: Retrieve Past Excel Workbook Versions Easily and Securely
  • Author: Paul
  • Created at : 2024-08-28 05:23:52
  • Updated at : 2024-08-29 05:23:52
  • Link: https://win-able.techidaily.com/retrieve-past-excel-workbook-versions-easily-and-securely/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Retrieve Past Excel Workbook Versions Easily and Securely