Imagine a situation where you are working on an Excel workbook with multiple sheets, containing data required for your reports or presentation but forgot to save it, or Excel crashes before saving the file. Do you know how to restore Excel files in such a situation? In this article, we’ve discussed solutions that you can use to restore a lost, unsaved, corrupt, inaccessible, or damaged Excel file by using MS Excel options and a third-party Excel repair tool.
Excel (XLS/XLSX) file corruption is a common issue that may arise due to problems, such as abrupt system shutdown, system crash, malware or virus intrusion, unsupported add-in, etc. However, MS Excel comes with a recovery feature that allows users to recover or restore Excel files lost or corrupted when the MS Excel quits unexpectedly or computer crashes due to hardware or software-related issues.
But sometimes, the restored version of the Excel file may not contain all the data or changes you made recently. In such cases, you are left with the option to repair the damaged or corrupt Excel file with the help of an Excel repair software, such as Stellar Repair for Excel.
Solutions to Restore Excel File
Below we have discussed various solutions to repair, recover, and restore unsaved, lost, corrupt, or inaccessible Excel files with the help of MS Excel options and Excel repair software.
NOTE: Some of these methods work only if you had enabled or configured certain required settings or options before corruption or losing the Excel file.
-
Restore Lost or Unsaved Excel File via ‘Recover Unsaved Workbooks’ Option
The Recover Unsaved Workbooks option allows you to restore previous version of the Excel file that you forgot to save before closing MS Excel or it stopped working. The steps are as follows:
- Navigate to ‘File > Open.’
- Scroll to the bottom and click on ‘Recover Unsaved Workbooks.’ This opens a File Explorer browser window.
- Now look for the Excel file that you lost and then double-click on it to open and restore the Excel file.
- Once the file is open, click on File > Save As and save it to your desired location.
However, this option works only if you had enabled and set up the ‘Save AutoRecover information every X minutes’ option and enabled the ‘Keep the last AutoRecovered version if I close without saving’ option.
Also, this may not restore the most recent copy of your Excel file, but it will surely save your time that went into creating and editing the workbook.
- Repair and Restore Corrupt or Inaccessible Excel File
If the Excel file you are trying to open or access is corrupt, MS Excel will display an error message. When MS Excel detects corruption, it starts ‘File Recovery Mode’ to repair the Excel workbook.
However, if it doesn’t start automatically, you can manually repair minor corruption error and restore the Excel file by following these steps:
- Navigate to File > Open and then navigate to the corrupt or damaged Excel file location.
- Select the file and then click on the arrow beside the ‘Open’ button to choose the ‘Open and Repair…’ option.
- Now click ‘Repair’ if you want to recover maximum data from a corrupt or inaccessible Excel workbook and restore it to a new Excel file.
If the ‘Repair’ option fails, use the Extract Data option that extracts values, data, and formulas from the Excel workbook.
- Revert Excel File to Last Saved Version
When an Excel file gets corrupt or damaged while working, you may revert the Excel file to the last saved version. This allows you to restore the Excel file version that isn’t corrupt or damaged. The steps are as follows,
- Click File > Open.
- Double-click the name of the workbook that you have opened in Excel.
- Click Yes to reopen the workbook.
The workbook opens without any changes you’ve made that might have caused the workbook to become corrupted.
- Use Excel Repair Software to Restore Excel File
If the corrupt or damaged Excel file isn’t repaired by using MS Excel options or you lost data after restoring the unsaved version or after reverting to the last version, you can rely on an Excel repair software, such as Stellar Repair for Excel.
The software repairs Excel files with 100% integrity and restores the Excel data, such as table, Pivot tables, charts, etc., while preserving the workbook properties and formatting. The software is safe as it doesn’t alter or make changes to the original Excel file and saves the repaired data to a new Excel workbook at your desired location.
It supports Excel files (XLS and XLSX), created in MS Excel 2019, 2016, or older versions. It resolves Excel corruption errors, such as Unable to open Excel file, in a few clicks.
To repair a corrupt or inaccessible Excel workbook by using Stellar Repair for Excel software, follow these 3 simple steps,
- Select the corrupt or damaged Excel workbook file (XLS/XLSX).
- Repair and then preview the Excel workbook.
- Save the workbook at default or your desired location.
Once saved, you can open and start editing or working on the Excel sheet. Make sure to enable AutoRecovery and AutoSave options to avoid data loss due to corruption.
Conclusion
In this article, we discussed methods and solutions to restore Excel file when it gets damaged or corrupt due to various issues. Although Excel can help you recover or restore Excel file after corruption, it can resolve only minor corruption errors. Thus, it may fail if the Excel file corruption is severe. In such cases, an Excel repair software, such as Stellar Repair for Excel, comes in handy. It resolves Excel corruption, repairs tables, charts, chart sheets, Pivot table, etc., and restores them to a new Excel sheet with 100% consistency.