IMPORTANT: This article contains information about modifying the registry. Before you
modify the registry, make sure to back it up and make sure that you understand how to restore
the registry if a problem occurs. For information about how to back up, restore, and edit the
registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows Registry
RESOLUTION
To resolve this behavior, rename the registry entries for the earlier or later versions of Excel. To do so, follow these steps.
Step 1: Determine the Version of Excel That You Are Running
- On the Help menu in Excel, click About Microsoft Excel.
The version of Excel that you are currently running is displayed in the About Microsoft Excel dialog box. - Quit Excel.
Step 2: Rename the Conflicting Excel Registry Subkeys
Registry entries for Excel are located in subkeys that correspond to the version, as shown in the following table:
Excel Version Subkey Name
------------------------------
97 8.0
2000 9.0
2002 10.0
In the steps that follow, you will rename the following subkeys for the earlier or later versions of Excel, where
Subkey Name is the subkey that represents the version of Excel:
HKEY_CURRENT_USER\Software\Microsoft\Office\Subkey Name\Excel
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Subkey Name\Excel
For example, if you are currently running Excel 2002, you will rename any Excel subkeys that appear in the
8.0 and
9.0 subkeys (if present). If you are currently running Excel 2000, you will rename the Excel subkeys that appear in the
8.0 and
10.0 subkeys (if present). To rename the subkeys, follow these steps.
WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may
require you to reinstall your operating system. Microsoft cannot guarantee that you can solve
problems that result from using Registry Editor incorrectly. Use Registry Editor at your own
risk.
- Click Start, and then click Run.
- In the Open box, type regedit, and then click OK.
- In Registry Editor, locate and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office
- Click the subkey that corresponds to the earlier or later version of Excel (for example, click 8.0).
- Right-click the Excel subkey, and then click Rename.
- Type OldExcel, and then press ENTER.
- Repeat steps d through f to rename any other subkeys for earlier or later versions of Excel.
- Locate and then click the following registry key:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office.
- Click the subkey that corresponds to the earlier or later version of Excel (for example, click 8.0).
- Right-click the Excel subkey, and then click Rename.
- Type OldExcel, and then press ENTER.
- Repeat steps i through k to rename any other subkeys for earlier or later versions of Excel.
- Quit Registry Editor.