Click the Open button on the File menu.
And select the Excel file that is causing the problem from the list.
Now select "Open and Repair" from the drop-down list on the "Open" tab.
Click the "Repair" button to repair the Excel file.