Method 1:
Open the recovered copy of the excel file.

1. Open Start -> All programs -> Microsoft Office -> Microsoft Office Tools and click "Microsoft Office Application Recovery"

2. In application list click Microsoft Excel , click recover application.

Note: Don't click End Application, otherwise recent changes to your workbook will be lost.

3. Open Microsoft Excel , the excel workbook you want to recover will be listed Document Recovery task pane.

4. To open or save your workbook, click the arrow on the right of the workbook in the task pane.

Method 2:
Use "Open and Repair" command

1. Start Microsoft Excel.

2. On the File menu, click Open.

3. In the Open dialog box, select the damaged excel file, Click the arrow on the Open button, and then click Open and Repair. Click the image below to enlarge.

4. When prompted click Repair to try to recover your most recent changes.

5. If you receive the following error message, click Yes.

6. Save your recovered workbook, that's it done!

Method 3:
Save the file in HTML format

This method is useful when you are not able to save the files as .xls file, see the steps below:

1. In Microsoft Excel the File menu, click Save as Web Page.

2. Under Save, click Entire Workbook, and then click Save.

3. Close the file and open the file again in Excel.

5. On the File menu, click Save As.

6. In the Save as type list, click Microsoft Excel Workbook.

7. Change the name of the file to create a new copy without replacing the original.