Recovering a Corrupted Excel file

If your excel file gets corrupted, when you open it Excel tries to repair it. If it fails, you can try a couple of alternatives to get what you can out of Excel.

• Start regedit, and go to this directory:
• HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
• Extract Values: Create a new DWORD called ExtractDataMode, and change the Value to 1
• Extract Values: Create a new DWORD called ExtractFormulas, and change the Value to 1

Remember to turn them back to 0 when you’re done.