This policy setting controls whether Excel 2007 presents users with a list of data extraction options before beginning an Open and Repair operation when users choose to open a corrupt workbook.
If you enable this policy setting, Excel 2007 opens the file using the Safe Load process and does not prompt users to choose between repairing or extracting data.
If you disable or do not configure this policy setting, Excel prompts the user to select either to repair or to extract data, and to select either to convert to values or to recover formulas.
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | ExtractDataDisableUI |
Value Type | REG_DWORD |
Enabled Value | 1 |
Disabled Value | 0 |