Click File > Open.
Click the location and folder that contains the corrupted workbook.
In the Open dialog box, select the corrupted workbook.
Click the arrow next to the Open button, and then click Open and Repair.
To recover as much of the workbook data as possible, pick Repair.
If Repair isn’t able to recover your data, pick Extract Data to extract values and formulas from the workbook.