Here are a few suggestions I've used in the past :
RESTORE CORRUPT FILE
ONLY DO THIS ON A COPY OF YOUR FILE. IF IT WORKS, THEN YOU CAN PERFORM THE SAME ON THE ORIGINAL.
Restoring a Corrupted File
This is the reply from one of members re restoring a corrupted file
The techs at Microsoft were able to restore the Excel file!
I'm not sure what all they did (some of it was magic, evidently), but here's a tip they passed along.
If you're having a problem with an Excel file, save it as HTML (which is one of the file types in Excel), then save it back to .xls
They say that will often recover lost information, or restore a corrupt file.
=================================================================================
http://directory.s2services.com/excel.htm
'provides a list of steps to recover a corrupt file
=================================================================================
https://support.office.com/en-us/ar...workbook-153A45F4-6CAB-44B1-93CA-801DDCD4EA53
=================================================================================
Another way of restoring broken/corrupted Excel files
I've been quite lucky actually opening corrupted files in OpenOffice, saving them, and then re-opening them in Excel. Sometimes the formatting will be a little off, but the data is almost always recovered, as well as most of the formatting. Unfortunately, not all of the formula and charts are, but when it happened I was happy anything was salvaged at all
![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)