When attempting to open a corrupt file, Excel automatically starts File Recovery mode to repair the file. But, if the recovery mode doesn’t start, try Microsoft Excel’s built-in ‘Open and Repair’ feature to manually repair the file. Way 1: Repair the Corrupt Excel File
Open a Blank workbook in Excel, and then click File > Open.
In the Open window, browse and select the corrupt file.
Click the arrow that is beside the Open tab, and select Open and Repair.
Implement one of the following:
Click Repair tab. (This is to recover as much data as possible.)
Click Extract Data tab. (This is to recover values and formulas from the Excel file if the repair process fails to recover the entire data.)
Way 2: Disable the Protected View Feature
Some Excel users have reported about turning off the ‘protected view’ feature in Excel to open a corrupt file. You can also try to disable this feature and open the file. To do so, follow these steps:
Step 1: Open a blank Excel file, click File > Options.
Step 2: In the Excel Options window, select Trust Center, and then click Trust Center Settings.
Step 3: Click OK.
Now check if you can open the corrupt file.
If the above manual methods fail, repair the corrupt Excel file by using third-party software solutions. The software helps repair Excel (XLS and XLSX) files easily and effectively.