Sunday, October 14, 2007

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.

No comments:

Sunday, October 14, 2007