How to Recover Corrupted Excel Files in Windows 10 [14 Tips]

Excel is an important program used by both individuals and businesses to process large amounts of data and organize it using formulas, tables, charts, and several other tools.

However, you may encounter different unexpected issues while using this program, one of which is file corruption errors due to system, virus infection, or other unknown reasons.

How to repair damaged Excel files?

If you encounter this situation, you can find several possible solutions below to help you solve the problem.

1. Check your computer for malware to repair Excel files

There is a high chance that your document is malfunctioning due to a virus attack. In this case, it might be a good idea to run a deep system scan using software on your computer.

The program should eliminate any viruses found, and you should be able to open the document. If you're looking for security tools, you'll be happy to know that some of the best antivirus software have free trials.

If you're not entirely sure which one best suits your own needs, you can try a few.

The most important thing to look for in an antivirus software is its threat database. Beyond that, make sure the security tool you choose has multiple layers of protection. This ensures you are protected in every way.

Other requirements that any antivirus software should check are a transparent privacy policy, low resource usage, and non-intrusive notifications.

After deciding on and installing an antivirus program, run a full PC scan and remove/quarantine any threats found.

2. Use third-party software to recover corrupted Excel files

Another possibility is to use professional data recovery software that can repair corrupted Excel documents.

Data recovery software scans your entire device for lost or damaged files. They will usually provide an overview of everything they can find and let you know which files can be recovered.

For Excel documents, specialized software is able to detect and eliminate the causes of corruption, allowing you to open the spreadsheet without any problems.

These tools are very powerful and come with additional recovery features that can help you recover complete lost disks and lost files on removable media.

3. Use the Open and Repair tool to repair Excel files

1. Open a blank Excel document.
2. Go to File and click Open.
3. In the Open dialog box, select the corrupted file, then click the drop-down menu next to Open and select "Open and Repair"

Note: To recover as much of the workbook data as possible, select Repair. If repair cannot recover your data, select Extract Data to extract values ​​and formulas from the workbook.

4. Restore damaged Excel file to previous version

1. Right click on the Excel file and select Properties
2. Go toPrevious versions, find and select the latest or correct version before Excel crashed, deleted or saved, then click Restore

Note: The workbook is opened without any changes that may cause the workbook to become corrupted.

5. Recover corrupted Excel files by changing the calculation method

Corrupted Excel files can be accessed by changing the workbook calculation method to manual.

This calculation is set to automatic by default, which means the workbook is calculated every time you try to open a file. Turning this feature off helps fix errors and allows you to open corrupted Excel files.

1. Open Microsoft Excel.

2. Click File and select New.

Expert Tip: Some PC problems are difficult to solve, especially if the repository is corrupted or Windows files are missing. If you are having trouble fixing errors, your system may be partially corrupted. We recommend installing Restoro, a tool that can scan your machine and determine where the fault lies.
Click here to download and start repairing.

3. Click Blank Workbook under New.

4. Navigate to File and go to Options.

5. Click Manual under Calculation Options in the Formula category.

6. Press OK to apply and save the changes.

7. Try to open the previously damaged Excel file.

6. Link to a corrupted workbook using external references

1. Click Fileand GoOpen
2. Go Find the folder containing the corrupted workbook and right-click on it.
3. Click to copy , then click to cancel.
4. Click File and go to New, then open a blank workbook.
5. In cell A1 of the new workbook, type =File Name!A1, where FileName is the name of the damaged workbook you copied in step 3 (without the extension), and then press Enter.
6. If the "Update Values" box appears, select the corrupted Excel and click OK.
7. If the Select Drawing dialog box appears, select the appropriate drawing and click OK.
Select cell A1 and click
8. Home, then click Copy.
Select a range, starting at cell A1, that is approximately the same size as the range of cells that contains the data in the damaged workbook.
9. Click
10. Home and Paste.
11. Repeat to copy all selected cells again by clicking Home and then click Copy.
Click
12. HomeGo to Paste and click Paste Value under Value.

Note: Pasting the values ​​will remove the link to the broken Excel, and you will be left with only the data.

By using this method, you will not be able to recover formulas, formats, charts, macros, etc., but recovering the data is better than recovering nothing.

7. Recover TMP files to repair corrupted Excel files

In File Explorer, open
1. This PC (usually C : )
Double-click the
2. Users folder, and then open the Default and AppData folders. (Make sure you can view hidden files.)
In the
3. Local folder, go to Microsoft.
Locate the
4. Office folder and go to UnsavedFiles.
5. Find and locate How to Recover Corrupted Excel Files in Windows 10 [14 Tips]orary excel files that begin with $ or ~ and end with .TMP
6. Copy these files Copy and save them to another safe location by changing the extension from .TMP to .XLS/.XLSX
##8. Delete TEMP folder to repair corrupted files in Excel

If saving How to Recover Corrupted Excel Files in Windows 10 [14 Tips]orary excel files doesn't work, another suggestion is to delete some How to Recover Corrupted Excel Files in Windows 10 [14 Tips]orary files and folders on your computer.

These files and folders can be found in the C:/Windows/How to Recover Corrupted Excel Files in Windows 10 [14 Tips] directory. After you delete these files, restart your computer and try opening the Excel document again.

If you are unable to delete How to Recover Corrupted Excel Files in Windows 10 [14 Tips]orary files, use our tutorial to resolve the issue.

9. Save the corrupted Excel file in HTML format and try to fix it

Open the Excel file and go to

Save As.
Select a different format from the drop-down menu of the "Save as type
2. " option. Then select the
web page.
3. Make sure the
entire workbook
4. is selected and click Save ##Right-click the web file and select Open with Microsoft Office Excel.
5. After opening the document, go to Save As
again and select the
6. Excel format. Choose a different name from the original corrupted file and press to save.
7. 10. Save the corrupted file in SYLK format to recover it

Open the Excel file and go to

Save as

1. Select a different format from the drop-down menu of the "Save as type
" option
2. From the drop-down list of options, select SYLK
(Symbolic Link) (*.slk)
3. Click File
again and
4. Open, but this time select the SYLK file. After opening the file, click File
and then click
5. Save As. Select the Microsoft Excel workbook
and click
6. Save.
Note

: Use SYLK format to save only the active worksheet. You must save each worksheet separately and repeat this process.

11. Recover corrupted Excel file by opening it in Wordpad or Word

Another solution we recommend is to try opening the corrupted Excel file in Wordpad document. If it works, WordPad will convert everything to text, but unfortunately, this method cannot recover formulas.

On the other hand, the good news is that unlike many other data recovery methods, WordPad will recover your macros.

Just search for Sub and Function in the recovered text to find them. You may also be able to open a corrupted .xls file in Word, but the results will be limited.

To do this, you first have to make sure you have the Microsoft Excel converter installed. You can download it from the official Microsoft page.

12. Open and recover corrupted Excel file using XML format

1. Open the corrupted file, go to File and click Save As.
2. Select XML Spreadsheet from the list of possible formats next to Save as type and click Save.
3. Open the document again.
4. Go to Save as again and save the document as an Excel workbook by selecting Excel format from the drop-down list next to Save as type.

13. Open the Excel file in safe mode to remove signs of corruption

1. Press Windows R key to open "Run"Dialog window
2. Type the commandexcel /safeand clickOK
3. Copy all data to the new document and open it in normal mode.

This method may disable your macros and add-ins, but it is a good solution because you can move the data to a new document.

14 Try recovering corrupted files using a newer Excel version

Although this may seem like a very simple solution, you should definitely give it a try.

Try to use a later version of Excel because as the version increases, the program's ability to recover files increases, so you can use this simple method to recover your files.

The above is the detailed content of How to Recover Corrupted Excel Files in Windows 10 [14 Tips]. For more information, please follow other related articles on the PHP Chinese website!