Article ID: 320058
Article Last Modified on 2/1/2007
APPLIES TO
- Microsoft Excel 2002 Standard Edition
This article was previously published under Q320058
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
SYMPTOMS
When you use the /automation command-line switch to start Excel, COM add-in programs load unexpectedly. (The /automation switch should disable all automatically opened files and auto-run macros.)
RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
307841 OFFXP: How to Obtain the Latest Office XP Service Pack
The English version of this fix has the following file attributes or later:
Date Time Size File name
-------------------------------------------------
21-May-2002 10:13 13,297,756 Excel.msp
21-May-2002 10:43 14,101,012 Excel_admin.msp
21-May-2002 14:18 2,626 Readme.txt
After the hotfix is installed, the following files will have the listed attributes or later:
Date Time Version Size File name
----------------------------------------------------------
20-May-2002 23:27 10.0.4115.0 9,173,320 Excel.exe
20-May-2002 23:27 10.0.4115.0 9,173,320 Excel.exe_1033
20-May-2002 23:27 10.0.4115.0 9,173,320 EXcel.exe_1049
After you install this fix, use the steps in the "How to Enable Hotfix by using the QFE_Jasper Registry Key" section of this article to set the QFE_Jasper registry key and to turn on the fix.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Microsoft Office XP Service Pack 2 (SP-2).
MORE INFORMATION
In Excel 2002, you can use the /automation switch to start Excel any of these ways:
- To load no COM add-ins or standard add-ins.
- To load only a specified add-in. To do this, list the ProgID of the COM add-in.
- To load multiple COM add-ins. To do this, list the ProgID for each one.
Example:
Excel.exe /automation Test.MyAddin MS.ComAddIn
The /automation switch can be combined with other existing command-line switches.
Example:
Excel.exe /automation COM Add-ins or XLAs, /a Automation Add-ins
How to Turn On the Hotfix by Using the QFE_Jasper Registry Key
To turn on the product fix listed in this article enter the following registry key and value. To do so:
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.
- Quit Excel if Exel is running.
- Click Start, and then click Run.
- In the Open box, type regedit, and then click OK.
- Locate and then select the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\
- Click the Edit menu, click New, and then click DWORD value.
- Type the following name for the new value:
QFE_Jasper
- Press the Enter key.
- Right-click the QFE_Jasper registry key, and then click Modify.
- In the Value data box, type 1.
- Click OK, and then quit Registry Editor.
Additional query words: prb XL2002
Keywords: kbhotfixserver kbqfe kbbug kbfix kbofficexppresp2fix kbofficexpsp2fix KB320058
