Get External Data Command Starts Two Copies of MSQuery
Article ID: 149043
Article Last Modified on 8/17/2005
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 95a
- Microsoft Excel 5.0 Standard Edition
- Microsoft Query 2000
This article was previously published under Q149043
SYMPTOMS
When you start Microsoft Query, two copies the program may be opened
instead of one. This behavior may occur when you click the Get External
Data command on the Data menu or when you use the Get External Data
option in the PivotTable Wizard.
CAUSE
Two copies of Microsoft Query may be started (one being Microsoft Query
version 1.0 and the other being Microsoft Query version 2.0), if the
following conditions are met:
- You start Microsoft query by clicking Get External Data on the
Data menu or by using the Get External Data option in the Pivot
Table Wizard.
-and-
- The Path statement in the Autoexec.bat file contains a reference to
the folder where Microsoft Query 1.0 (Msquery.exe) resides.
WORKAROUND
To avoid opening two copies of Microsoft Query as mentioned above,
remove the reference to the directory containing Msquery.exe from the
Autoexec.bat file.
NOTE: The file name for Microsoft Query 2.0 is Msqry32.exe.
MORE INFORMATION
MSQuery 1.0 is shipped with Microsoft Excel version 5.0 and is located
in the Windows\Msapps folder (usually the C:\Windows\Msapps).
Additional query words: 7.00a 8.00 97 multiple incorrect XL
Keywords: kbualink97 KB149043