To resolve this problem, obtain the latest service pack for Microsoft Office 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
276367 How to obtain the latest Office 2000 service pack
After you apply the latest Microsoft Office 2000
service pack, create the
QFE_Nice and the
QFE_Ontario registry entries to resolve this issue. This
fix is also included in Excel 2002, Excel 2003, and Excel 2007. To enable the fix in these products, you can also use the following procedure.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
To
do this:
- Exit Excel,
if Excel
is running.
- Click Start, and then click
Run.
- In the Open box, type
regedit, and then click OK.
- Depending on the version of Excel that you are using, verify that the following registry subkey exists.
Note If the registry subkey does exist, go to step 5.
Excel
2000HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options\
Excel 2002HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\
Excel 2003HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\
Excel 2007HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\
- If
the registry key path does not exist, create the registry key path. To create
the registry key path, locate and then select the following registry key:
HKEY_CURRENT_USER\Software\Microsoft
- Click the Edit menu, click
New, and then click Key.
- Type Office, and then press
ENTER.
- Click the Edit menu, click
New, and then click Key.
- For Excel
2000, type 9.0, and then press the
ENTER.
Note
Type the following values, depending on the version of Excel that you use, and then press ENTER:- For Excel 2002, type 10.0.
- For Excel 2003, type 11.0.
- For Excel 2007, type 12.0.
- Click the Edit menu, click
New, and then click Key.
- Type Excel, and then press the
ENTER.
- Click the Edit menu, click
New, and then click Key.
- Type Options, and then press the
ENTER.
- Click the Edit menu, click
New, and then click DWORD Value.
- Type the following name for the new value:
QFE_NICE
- Press ENTER.
- Right-click the new DWORD value name, and then click
Modify.
- In the Value data box, type
1 and then click OK.
- Repeat steps 5 through to step 9, and then substitute the
registry DWORD value QFE_NICE with the following registry DWORD value:
QFE_ONTARIO
- Exit Registry Editor.