iSumsoft » Windows Tips »My Excel File is Corrupted. How to Open it?

My Excel File is Corrupted! How to Open it?

Lucas Watson
Lucas Watson

Updated:

Excel is a powerful tool for managing data and creating complex spreadsheets. However, sometimes things can go wrong, and your document may be corrupted and unreadable. This is frustrating, especially when the file contains essential data that you need to access. If you are struggling with data loss, don't panic - there are several ways for you to recover your corrupted Excel file and get it open again.

my-excel-file-is-corrupted-how-to-open-it


Method 1: Excel automatically starts File Recovery mode to repair corrupted Excel file

File Recovery mode is a built-in feature in Excel that can assist you in recovering the corrupted file. When you open a corrupted Excel file, Excel will automatically detect the issue and prompt you to open the file in File Recovery mode. Once you're in this mode, Excel will try to repair the file and recover as much data as possible.

Step 1: Copy the corrupted Excel file (using the file Excel Repair.xlsx as an example) in case of being overwritten, and rename it (as Excel Repair-1).

copy-the-corrupted-file

Step 2: Double-click to open the corrupted Excel file. The application will automatically start Recovery mode to repair the corrupted file, click Yes to recover.

click-yes-to-repair

Step 3: Click Close after the recovery.

click-close

Step 4: Save the repaired Excel file and rename it (as Excel Repair-2).

rename-it-excel-2

Method 2: Start File Recovery mode manually to open corrupted Excel file

If Excel does not launch the File Recovery mode according to the solution mentioned above, you can start it manually.

Step 1: Click on File to new a workbook.

click-on-file

Step 2: Click Open » Browse.

click-open-and-browse

Step 3: Choose the dropdown button of Open and select Open and Repair.

select-open-and-repair

Step 4: Select Repair or Extract.

click-repair

Step 5: Click Close.

click-close

Step 6: Save the recovered file and rename it (as Excel Repair-3).

rename-it-excel-3

Solution 3: Check the Excel Calculation options to open corrupted Excel file

Step 1: Click on File » Options » Formulas.

navigate-to-formulas

Step 2: Check Manual in the Calculation options, then enter OK.

check-manual

Step 3: Back to the home page, click File » Open » This PC » Excel Repair-1.xlsx.

click-open-and-this-pc

Step 4: Click Yes.

click-yes-to-repair

Step 5: Click Close.

click-close

Step 6: Save it and rename it (as Excel Repair-4).

rename-it-excel-4

Solution 4: Recover and open the corrupted Excel file with the professional tool

If all methods above do not work, you could try a third-party tool to open the corrupted Excel file.

iSumsoft Excel Refixer is an Excel file recovery tool used to repair/recover corrupted Microsoft Excel (.xlsx) files, ensuring to repair corrupted Excel files and restore all data to their original state, preserving 100% integrity of all data and formats. If your Excel file is corrupted and cannot be opened or read, this tool will help you repair it and salvage all the data.

Step 1: Download and install iSumsoft Excel Refixer.

download excel refixer

Step 2: Launch the software, and click the Add button on the home page.

click-add-button

Step 3: When a dialog box opens, navigate to the corrupted Excel file, then choose it and click Open.

add-excel-file

Step 4: After choosing the target file, click Restore.

click-restore

Step 5: Click OK after the recovery.

excel-file-recovered

Step 6: Click Save.

click-save

Step 7: Storing it to a specific location, you will be asked to Open it now or not. Click on one of them.

excel-file-saved