To resolve this issue, use method 1. If method 1 is not successful, use method 2.
Method 1: Rename Excel Registry Key
To resolve this issue, you must rename the registry key for Excel. This forces Excel to generate a new key the next time that you start Excel.
To do this, 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 the following subkey in the registry:
HKEY_CURRENT_USER\Software\Microsoft\Office\9.0
- Right-click the subkey, and then click Rename.
- Type OldExcel, and then press ENTER.
- In Registry Editor, locate the following subkey in the registry:
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0
- Right-click the subkey, and then click Rename.
- Type OldExcel, and then press ENTER.
- Quit Registry Editor.
- Start Excel.
If the problem still occurs, go to method 2.
Method 2: Rename the Excel.pip File
Excel displays the most recently used menus and commands. Excel hides the unused commands in its expandable menus. Excel stores this usage data with menu animation settings in a file named Excel.pip.
To rename the Excel.pip file, follow these steps:
- Start Windows Explorer.
- Right-click the hard disk where Windows is installed, and then click Search.
- In the All or part of the file name box, type Excel.pip, and then press Search.
- Right-click Excel.pip in the Search Results pane, and then click Rename.
- Type Oldexcel.pip, and then press ENTER.
- Quit Search.
- Quit Windows Explorer.
- Start Excel.