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.
Remember to turn them back to 0 when you’re done.
- 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