Excel File Corrupted: How to Repair

Many people have reported an issue that their Excel files are corrupted. Some see an error message occur, but many just can’t open the files.

If you’re also experiencing this issue, you’re no doubt very frustrated. But don’t worry. The following are a few tips that have helped many people repair their excel files.

Try this method

To repair your Excel file:

1. Open the Excel program.
2. Click Open Other Workbooks or File.
   

   

   

3. Click Open, then click Browse.

   

4. Select your corrupted Excel file, then click the arrow next to Open and select Open and Repair.

   

5. Click the Repair button (to ask Excel to save as much as possible from your corrupted file).

   

6. If this can’t repair your file, do step 1 to 4 again, and click the Extract Data button to extract your data from the corrupted excel file.

   

   
   Then select Convert to Values if you’re OK with converting all your formulas or calculations to its values or results. Or select Recover Formulas if you want to keep your formulas.

   

Hopefully, this has repaired your Excel file. If you have any questions or suggestions, you’re more than welcome to leave us a comment below.

By Jonny Lin

Jonny, a Microsoft Certified Professional, is a technical writer and technology enthusiast. He believes technology should bring users satisfaction, not annoyance, so he writes to help people overcome their tech troubles.

View all of Jonny Lin's posts.