Excel opens the file by using the Safe Load process. If ExtractDataDisableUI equals 1, Excel does not offer you any options during the Open and Repair process. The second message prompts you to choose either to convert to values or to recover formulas. The first message prompts you to choose either to repair or to extract data. If ExtractDataDisableUI equals 2 (or a value that is not valid), Excel prompts you with two messages during the Open and Repair process. In the list of registry entries, double-click ExtractDataFormulas.
To change the value from 2 to 1, follow these steps: This value also affects the default option when you are prompted to recover formulas during the Open and Repair process. If ExtractDataFormulas equals 1, Excel recovers as much of the formula as possible, and substitutes #REF if recovery does not succeed. 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. Type 1in the Value data field, and then click OK. In the list of registry entries, double-click ExtractDataMode. Locate the following registry subkey, as appropriate for the version of Excel that you are running: Microsoft cannot guarantee that these problems can be solved. These problems might require that you reinstall the operating system. Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. To change the value from 2 to 1, follow these steps. Therefore, Excel does not try to recover anything other than the data in the workbook. If ExtractDataMode equals 1, Excel assumes that the structure of the workbook is corrupted. Therefore, Excel tries to recover the whole workbook, including formulas, formatting, and Microsoft Visual Basic for Applications (VBA) projects. If ExtractDataMode equals 2 (or a value that is not valid), Excel assumes that the structure of the workbook is not corrupted.
In these subkeys, 2 is always the default value, and 1 is the only other valid value. These subkeys contains three DWORD registry values that you can modify as follows.
HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Excel\Options HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\11.0\Excel\Options HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\10.0\Excel\Options To do this, click Open on the File menu, click the arrow on the Open button, and then click Open and Repair.Īll the registry values that affect data recovery are in the following registry subkeys, depending on which version of Excel you are running: You can also manually start the data recovery process. If Excel detects a problem in a workbook, the data recovery process begins automatically. When you open a workbook in Excel, Excel checks for problems in the workbook.
HOW TO REPAIR MICROSOFT EXCEL 2003 HOW TO
This article describes how to use the registry to override the default behavior when Excel tries to recover data. Microsoft Excel contains a feature that allows you to recover data from corrupted workbooks.
HOW TO REPAIR MICROSOFT EXCEL 2003 WINDOWS
For more information about how to back up, restore, and modify the registry, see Description of the Microsoft Windows registry. Make sure that you know how to restore the registry if a problem occurs. Make sure that you back up the registry before you modify it. This article contains information about how to modify the registry. Registry keys that control the File Repair feature in Excel
0 kommentar(er)
