1.Open a blank Excel workbook.
Find the desired file and choose Open and Repair. This option is in the drop-down list associated with the Open button.
If Excel cannot open the file, choose Extract Data.
Confirm by clicking Yes. If Excel warns you that the file caused a serious error the last time it was opened, agree to continue opening it.
2.Copy Data Method
If you can, open the file.
Right-click a sheet tab and choose Select All Sheets.
Right-click a sheet tab and choose Move or Copy.
Choose New Book and check the Create a Copy box.
or Close Excel, re-open it, and try to open the file again.
If this doesn't work, restart the computer, open up Excel and try to open the file again.
If this doesn't work, delete the contents of your c:\windows\temp directory then reboot. Try again.
If this doesn't work, open the file using OpenOffice. This is free, Microsoft-compatible software that may be able to work around the corruption.
If this doesn't work, open Excel in Safe Mode. This will disable VBA and Add-ins.
Restart the computer in Safe Mode.
Click on Start then Run then enter the actual path to the executable file. Depending on your version of Windows, this may be C:\Program Files\Microsoft Office\Office\excel.exe, C:\Program Files (x86)\Microsoft Office\Office11\excel.exe, or something similar. (For Excel 2002, Office XP, click cancel if the MS Office Installer starts; Excel in safe mode will still start)].
Try to open the file.
3.IF YOU want to recover the corrupt files to the original format, try easeus data recovery wizard, With it, you can undelete word documents, recover formatted word files or recover lost Excel files