How to Restore Previous Version of Excel File?

Summary: If you’ve accidentally closed the Excel file without saving it, then you can restore the previous version of the file using the inbuilt features in Excel and Windows. This article discusses the ways to restore the previous version of the Excel file. Further, it discusses an Excel file repair tool that can help repair and restore corrupt Excel files.

Sometimes, while working on an Excel file, you accidentally close the file or your system shuts down suddenly due to power failure, or the Excel program crashes due to an issue.

As a result, the file you’re working on will not be saved and you fear losing your data. However, there is no need to worry as the Excel program has features that can help you restore such unsaved files.

One such feature in the Excel application is the AutoRecover feature. If this feature is enabled, it automatically saves the versions of the file.

In this article, we’ll mention different ways to restore the previous version of the Excel file.

Methods to Restore Previous Version of Excel File

Follow the below-listed methods to restore the previous version of the Excel file using the inbuilt functions of Excel and Windows.

Method 1: Use Document Recovery Pane in Excel

The Document Recovery pane in Microsoft Excel helps to review, open, and save the recovered files. If your Excel program closes unexpectedly before saving the changes, you can use the Document Recovery pane to restore the file.

Here are the steps to restore the file using the Document Recovery pane:

Method 2: Use the Manage Workbook Option in Excel

Manage Workbook is an inbuilt feature in Excel that you can use to recover the previous version of the Excel file. If your Excel file is closed without saving, this option can help you to open the file and save it. Follow these steps to restore the file:

Method 3: Use the File History Feature in Windows

You can also restore the previous version of the Excel file by using the Windows File History feature. However, to use this feature, you must have enabled it beforehand. Here are the steps:

What if the file doesn’t open?

If the Excel file doesn’t open, it indicates corruption in the file. An Excel file may get corrupted due to an abrupt system or program shutdown, system or application crash, etc.

When Microsoft Excel detects a corrupted worksheet upon opening, it automatically starts File Recovery mode and starts repairing it. However, if the File Recovery mode fails to start, then you can use the Open and Repair utility in Excel to recover the corrupted workbook. Follow these steps:

If the Open and Repair tool does not work, then you can use advanced Excel repair software, such as Stellar Repair for Excel. This Excel repair software can easily repair severely corrupted Excel files and recover all the data in just a few steps. 

Conclusion

You can use the methods mentioned above to restore the previous version of the Excel File. If the file is corrupt, you can repair the file using Microsoft’s Open and Repair tool or use a professional Excel file recovery tool, such as Stellar Repair for Excel. This tool can repair severely corrupted files and restore all the Excel file data with complete integrity. You can download the free version of the software to scan the corrupt Excel file and preview the recoverable data.

Related Post

Exit mobile version