Assume structured storage format of workbook is intact when recovering data

When this setting is enabled and the user is in an ''Open and Repair'' operation, Excel assumes that the structure of the workbook is not corrupted and therefore tries to recover the whole workbook, including formulas, formatting, and Microsoft Visual Basic for Applications (VBA) projects. When this setting is not enabled, Excel assumes that the structure of the workbook is corrupted and therefore does not try to recover anything other than the data in the workbook.

Supported on: At least Windows Vista

Registry HiveHKEY_CURRENT_USER
Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options
Value NameExtractDataMode
Value TypeREG_DWORD
Enabled Value0
Disabled Value1

excel12.admx

Administrative Templates (Computers)

Administrative Templates (Users)