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.

Hi mudraker,

Thanks for that one, just for reference here's a couple more

http://www.exceltip.com/st/Recoverin...pened/678.html

http://www.s2services.com/excel.htm

A couple more links as supplied by Leith Ross a a reply to
http://www.excelforum.com/showthread...=1#post1863648

How to recover data from damaged workbooks in Excel 2002 and 2003
http://support.microsoft.com/kb/8207...d=2512&sid=106

How to handle corrupt Excel workbooks by saving them in the SLYK format in Excel 2003 or Excel 2002
http://support.microsoft.com/kb/3006...d=2512&sid=106

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 :-)