قالب وردپرس درنا توس
Home / Tips and Tricks / View and restore previous versions of Excel workbooks

View and restore previous versions of Excel workbooks



Microsoft Excel logo

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 sure AutoSave is enabled

Make as many changes to this document as you want. When you’re done, click on the file name in the top bar.

Click on the file name

Select ‘Version History’.

Click Version History

You can also click the “File” button at the top.

Click on File

Select “Info” in the left pane.

Click on Info

Click on ‘Version History’.

Click 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.

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 versie

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’.

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




Source link