Generally, Excel file gets corrupts easily but you can recover it with your Backup file. In case, you don’t have the Backup file then you can follow the below method to open corrupt Excel file without any backup. If in case, you need technical assistance you can contact to the expert of Microsoft team through www.office.com/setup.
Method To Open Corrupt Excel File Without Any Backup:
- Open and Repair Utility:
You should click on MS Office and then choose Open. Now in the Open dialog box, you have to select corrupt Excel file. Then, you should click on the arrow beside the Open tab and after this, just select Open and Repair option. Here, you have to choose any one of the following options: You can click on the Repair tab just to recover maximum data as possible or you can click on the Extract Data tab just to recover values and formulas from Excel file.
- Use Excel AutoRecover and Autobackup Features:
AutoRecover and AutoBackup feature of Excel helps to reduce the chances of data loss in Excel files. You can use these features to open corrupt Excel file without any backup.
Excel AutoRecover – It helps to saves the worksheets automatically at a temporary location and you can also recover file automatically.
For this, you should open your Excel application and then click on the File tab. Now from the file menu, you should click on the options button. Then, it will open the Excel options Window. Here, on the Window’s left sidebar, you should click on the save option. Now, you should check mark both the option “Save AutoRecover information every” and “Keep the last AutoSaved version if I close without saving”. Here, you can also set time interval.
Sometimes, the AutoRecover feature stopped working. Then, you can use Excel AutoBackup.
Excel AutoBackup – It also helps to reduce data loss chances just by creating Excel backup. It is not fully safe but helps to restore Excel data without any backup.
- Recover Excel Data From The TMP File:
First of all, you have to open the temp folder location and then you have to locate the Excel temp files with TMP extension.
For Windows 8/10 users, you should go to below path- C:\Users\\AppData\Local\Microsoft\Office\UnsavedFiles
For Windows 7 users, you should go to below path- C:\Users\name\AppData\Roaming\Microsoft\Excel\
After this, you should locate temporary Excel files which starts with “$” or “~” and end with “.TMP”. Now, you should copy the files and just save to another Safe location. Here, you have to change the extension from .TMP to .XLS/.XLSX. At last, you can recover corrupted/damaged XLS/XLSX file easily. www.office.com/setup
- Open Excel File in Safe Mode:
For this, you have to restart your PC in safe mode and then check that you are able to access the Excel file. After this, just click on files and then choose the options. Now, you have to click on the Add-ins. At the bottom of the page, you will see the option Manage. Just ensure that it is set to “COM Add-ins” and then just click on “Go” option. After this, you have to uncheck the“ABBYY FineReader xxxxxxx COM Add-in” and just select “OK” button. At last, you have to restart you PC.
The above method will help you to open corrupt Excel File Without Backup. But in case, the user needs help then they can contact to MS Office via office.com/setup.
more information: How User Can Protect Their Privacy in Window 10?