On the File tab, click Open.
In the Open dialog box, select the corrupted workbook that you want to open.
Click the arrow next to the Open button, and then click Open and Repair.
Do one of the following:
To recover as much of the workbook data as possible, click Repair.
To extract values and formulas from the workbook when an attempt to repair the workbook is not successful, click Extract Data.