Information used by Excel 2003 is stored in this Registry section:
In this section of the Registry, you'll find a number of keys that contain specific values that determine how Excel operates.
The Registry settings are updated automatically by Excel when Excel closes.
It's important to understand that Excel reads the Windows Registry only once — when it starts up. In addition, Excel updates the Registry settings only when Excel closes normally. If Excel crashes (unfortunately, not an uncommon occurrence), the Registry information is not updated. For example, if you change one of Excel's settings, such as the visibility of the status bar, this setting is not written to the Registry until Excel closes by normal means.
Table 4-2 lists the Registry sections that are relevant to Excel 2003. You might not find all these sections in your Registry database.
Table 4-2 EXCEL CONFIGURATION INFORMATION IN THE REGISTRY
AutoSave Converters Delete Commands
Lists add-ins that appear in the list box when you choose the Tools ^ Add-Ins command. Add-ins that are included with Excel do not appear in this list. If you have an add-in entry in this list box that you no longer use, you can remove it by using the Registry Editor.
Holds the AutoSave option that you set.
Lists additional (external) file converters that are not built into Excel.
Enables you to specify which menu commands you don't want to appear.
Table 4-2 EXCEL CONFIGURATION INFORMATION IN THE REGISTRY (Continued)
Error Checking Holds the settings for formula error checking.
Init Commands Holds information about custom commands.
Line Print Holds settings used in 1-2-3 macro printing. Excel updates this section whenever it executes a 1-2-3 macro that has /wgdu (Worksheet Global Default Update) in it.
Options A catch-all section; holds a wide variety of settings, including the paths to files that are opened automatically when Excel starts (such as add-ins).
Recent Files Stores the names of the last files saved (up to nine files).
Recent Templates Stores the names of templates you've used recently.
Resiliency Information used for recovering documents.
Security Specifies the security level for opening files that contain macros.
Spell Checker Stores information about your spelling checker options.
Although you can change most of the settings via Excel's Options dialog box, several other useful settings cannot be changed directly from Excel (but you can use the Registry Editor to make changes).
One more warning is in order. Prior to making any changes to the Registry, refer to the sidebar "Before You Edit the Registry ...".
Was this article helpful?