Microsoft Office Tutorials and References
In Depth Information
Excel Settings in the Registry
Before you edit the Registry . . .
You can use the regedit.exe program to change anything in the Registry, including
information that is critical to your system’s operation. In other words, if you change the wrong piece of
information, Windows may no longer work properly.
Get into the habit of choosing the File➜Export command in Regedit. This command enables you
to save an ASCII version of the entire Registry or just a specific branch of the Registry. If you
find that you messed up something, you can always import the ASCII file to restore the Registry
to its previous condition (choose the File➜Import command). Refer to the Help file for Regedit
The Registry consists of keys and values, arranged in a hierarchy. The top-level keys are
Information used by Excel 2010 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 formula bar, this setting is not written to the Registry until Excel
closes by normal means.
Table 4-6 lists some of the Registry sections that are relevant to Excel 2010. You may not find all
these sections in your Registry database, and you may find some others.