- A corrupt Excel file can result in a lot of wasted time and severe data loss.
- So it's important to know how to recover your Excel data, and the simple steps below will surely help.
- Similar guides can be found in our Office 365 collection of articles, so take a look.
- For other tutorials on almost everything software-related, see the How-To page.
Excel is a crucial program used both by individuals and businesses to work with large amounts of data and organize it using formulas, tables, charts, and several other tools.
However, while using the program, you can encounter different unexpected problems, one of them being file corruption error due to the system, virus infections, or other unknown reasons.
If you face this situation, you can find below several possible solutions that can help you solve the problem.
How can I fix Excel file corruption problems?
- Check for malware
- Use a third-party software
- Use the Open and Repair tool
- Restore corrupted Excel file from the previous version
- Set calculation option to manual
- Use external references to link to the corrupted workbook
- Recover TMP file
- Delete TEMP folder
- Use the HTML format
- Use SYLK format
- Open in WordPad or Word
- Use the XML format
- Open the Excel in Safe Mode
- Use newer Excel versions
1. Check for malware
It is very likely that your document could be malfunctioning due to a virus attack.
In this case, it might be a good idea to run a deep systems scan using the software you have on your computer. The program should eliminate any viruses found and you should be able to open the document.
For the best antivirus tool to use presently, the recommendation is Bitdefender.
With Bitdefender, you get top-notch protection against the latest known malware, multi-layered ransomware shield to keep your files safe, plus protection against online phishing and fraudulent attempts.
Besides, by activating the real-time protection feature, you can actually prevent your system to get infected. There are plenty of other useful features that this product has, including various working modes, performance optimization tools, or safe online banking.
Download Bitdefender, open the tool, and run a system scan, a mentioned. The whole process might take some time. Allow the tool to delete any threats that it can find and also repair or optimize your system.
Bitdefender Antivirus PlusKeep your most valuable data at bay from malware infections with Bitdefender's top online security solutions.
2. Use a third-party software
Another possibility is to use a professional data recovery program to restore corrupted Excel files.
The best option in this case is Stellar Repair for Excel.
This is a great software option that allows you to repair Excel data, or at least to extract it from the corrupted files, in the original format.
The tool is compatible with several Excel versions, starting with the 2000 version, up until the latest ones.
Stellar Repair for ExcelRestore your corrupted Excel files to their original form in just a few steps, using this simple and efficient tool.
3. Use the Open and Repair tool
- Open a blank Excel document.
- Go to File and click Open.
- In the Open dialog box, select the corrupted file and then click on the drop-down menu next to Open to select Open and Repair
Note: To recover as much of the workbook data as possible, pick Repair. If Repair is not able to recover your data, pick Extract Data to extract values and formulas from the workbook.
4. Restore corrupted Excel file from the previous version
- Right-click on the Excel file and select Properties
- Go to Previous Versions, find and select the latest version or the right version before Excel crashes, deleted or saved, click Restore
Note: The workbook opens without any changes you made that might have caused the workbook to become corrupted.
5. Set calculation option to manual
- Open Excel, click on File and choose New
- Click Blank workbook under New
- Navigate to File and go to Options
- Click Manual under Calculation options in Formulas category and press OK
6. Use external references to link to the corrupted workbook
- Click File and go to Open
- Go to the folder that contains the corrupted workbook and right-click on it.
- Click Copy, and then click Cancel.
- Click File and go to New, then open a Blank workbook.
- In cell A1 of the new workbook, type =File Name!A1, where FileName is the name of the corrupted workbook that you copied in step 3 (without the name extension), and then press Enter.
- Select corrupted Excel if the Update Values box appears and click OK.
- Choose the appropriate sheet if the Select Sheet dialog box appears and click OK.
- Select cell A1 and click Home and then Copy.
- Select an area, starting in cell A1 that is approximately the same size as the range of cells that contain data in the corrupted workbook.
- Click Home and Paste.
- Repeat to copy all selected cells again by clicking Home and then Copy.
- Click Home go to Paste and click Paste Values under Values.
Note: Pasting values will remove the links to corrupted excel and leave you only with the data by then.
By using the method, you won’t be able to recover formulas, formats, charts, macros, and so on, but recovering the data is better than recovering nothing.
7. Recover TMP file
- In File Explorer, open This PC (usually C: )
- Double click the Users folder and then open the Default and AppData folder. (Make sure you can view hidden files.)
- In the Local folder, go to Microsoft.
- Locate the Office folder and then go to UnsavedFiles.
- Locate and find the temporary excel files beginning with $ or ~ and end with .TMP
- Copy these files and save them to another safe spot by changing the extension from.TMP to .XLS/.XLSX
8. Delete TEMP folder
If saving a temporary excel file did not work, another suggestion is to delete some of the temporary files and folders on your computer.
These files and folders can be found in C:/Windows/temp directory. Once you have deleted these files, restart your computer and then try opening the Excel document again.
If you can’t delete temporary files, use this guide to fix the problem.
9. Use the HTML format
- Open the Excel file and go to Save As.
- Choose other formats from the drop-down menu in the Save As Type option.
- Then select Web Page.
- Make sure entire Workbook is selected and then click on Save
- Right-click on the web file and choose Open with Microsoft Office Excel.
- Once the document is open, go to Save As again and choose the Excel format.
- Choose a different name than the original corrupted file and press Save.
10. Use SYLK format
- Open the Excel file and go to Save As
- Choose other formats from the drop-down menu in the Save As Type option
- From the options in the drop-down list, select SYLK(Symbolic Link) (*.slk)
- Click File and Open again, but this time choose the SYLK file.
- Once the file is open, click File and then Save As.
- Choose Microsoft Excel Workbook and click Save.
Note: Using the SYLK format only saves the active worksheet. You will have to save each worksheet individually and repeat this procedure.
11. Open in WordPad or Word
Another solution that we recommend is to try opening your corrupt file in WordPad. If it works, WordPad will convert everything to text but unfortunately, this method will not recover formulas.
On the other hand, the good news is that unlike many other data recovery methods, WordPad will recover your macros.
Simply search the recovered text for Sub and Function to find them. You might also be able to open the corrupted .xls file in Word, but the results will be limited.
In order to do so, you first have to make sure you have the Microsoft Excel Converter installed. You can download it from Microsoft’s official page.
12. Use the XML format
- Open the corrupted file, go to File and click on Save As.
- From the list of possible formats next to Save as Type select XML Spreadsheet and then click Save.
- Open the document again.
- Go to Save As again and then save the document as an Excel Workbook by choosing Excel format from the drop-down list next to Save as Type.
13. Open the Excel in Safe Mode
- Press Windows+R keys to open the Run dialogue window
- Type the command excel /safe and click OK
- Copy all of the data to a new document and open it in Normal Mode.
This method may disable your macros and Add-ins but it is a great solution because you can move the data to a new document.
14. Use newer Excel versions
Although it seems like a very simple solution, you should definitely try it as well. Try to use a later Excel version because as the versions increase, the ability for the program to recover a file increases also, so you might be able to recover your file using this simple method.
So, has any of these solutions helped you to fix your corrupted Excel file? Let us know in the comments section below.
Editor’s Note: This post was originally published in September 2018 and was completely revamped and updated in August 2020 for freshness, accuracy, and comprehensiveness.Editor's Note: This article was originally published in September 2018 and was revamped and updated in November 2020 for freshness, accuracy, and comprehensiveness.