Microsoft KB Archive/289840

= Registry keys that control the File Repair feature in Excel =

Article ID: 289840

Article Last Modified on 1/26/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q289840



This article is a consolidation of the following previously available articles: 289840 and 826836 Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



SUMMARY
Microsoft Excel contains a feature that allows you to recover data from corrupted workbooks. This article describes how to use the registry to override the default behavior when Excel tries to recover data.



MORE INFORMATION
When you open a workbook in Excel, Excel checks for problems in the workbook. If Excel detects a problem in a workbook, the data recovery process begins automatically.

Note You can also manually start the data recovery process. To do this, click Open on the File menu, click the arrow on the Open button, and then click Open and Repair.

All the registry values that affect data recovery are in the following registry subkeys, depending on which version of Excel you are running:

Microsoft Office Excel 2007
These subkeys contains three DWORD registry values that you can modify as follows.

Note In these subkeys, 2 is always the default value, and 1 is the only other valid value.

ExtractDataMode
If ExtractDataMode equals 2 (or a value that is not valid), Excel assumes that the structure of the workbook is not corrupted. Therefore, Excel tries to recover the whole workbook, including formulas, formatting, and Microsoft Visual Basic for Applications (VBA) projects.

If ExtractDataMode equals 1, Excel assumes that the structure of the workbook is corrupted. Therefore, Excel does not try to recover anything other than the data in the workbook.

To change the value from 2 to 1, follow these steps.

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.  Start Registry Editor.  Locate the following registry subkey, as appropriate for the version of Excel that you are running:

Excel 2007
 In the list of registry entries, double-click ExtractDataMode. Type 1 in the Value data field, and then click OK.

ExtractDataFormulas
If ExtractDataFormulas equals 2 (or a value that is not valid), Excel tries to recover formulas and converts a formula to a value if recovery does not succeed.

If ExtractDataFormulas equals 1, Excel recovers as much of the formula as possible, and substitutes #REF if recovery does not succeed. This value also affects the default option when you are prompted to recover formulas during the Open and Repair process.

To change the value from 2 to 1, follow these steps:  Start Registry Editor.</li>  Locate the following registry subkey, as appropriate for the version of Excel that you are running:

Excel 2007
</li> In the list of registry entries, double-click ExtractDataFormulas.</li> Type 1 in the Value data field, and then click OK.</li></ol>

ExtractDataDisableUI
If ExtractDataDisableUI equals 2 (or a value that is not valid), Excel prompts you with two messages during the Open and Repair process. The first message prompts you to choose either to repair or to extract data. The second message prompts you to choose either to convert to values or to recover formulas.

If ExtractDataDisableUI equals 1, Excel does not offer you any options during the Open and Repair process. Excel opens the file by using the Safe Load process. Data extraction is still enabled through the object model and through automatic data recovery.

To change the value from 2 to 1, follow these steps:  Start Registry Editor.</li>  Locate the following registry subkey, as appropriate for the version of Excel that you are running:

Excel 2007
</li> In the list of registry entries, double-click ExtractDataDisableUI.</li> Type 1 in the Value data field, and then click OK.</li></ol>

Keywords: kbhowto KB289840

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.