Knowledge Base

XL98: "Command Cancelled" or Query Error Creating New Query

Article ID: 177348

Article Last Modified on 8/25/2006

APPLIES TO

This article was previously published under Q177348

SYMPTOMS

When you point to Get External Data on the Data menu and click Create New Query, you receive one of the following error messages:
Command cancelled.
Microsoft Excel did not receive any information from Microsoft Query.

-or-

Microsoft Query could not be started.

You must have Microsoft Query and ODBC installed on your computer in order to run it.

If Microsoft Query or ODBC is not installed on your computer, run the Value Pack installer to install it.

CAUSE

This problem occurs if Microsoft Query version 1.0 and Microsoft Query version 8.0 are both installed on the computer.

WORKAROUND

To work around this problem, follow these steps:
  1. Remove Microsoft Query version 1.0.
  2. Reinstall Microsoft Query version 8.0. To do this, follow these steps:

    1. Insert the Microsoft Office 98 Macintosh Edition compact disc (CD) into the CD-ROM drive.
    2. Double-click the Value Pack folder.
    3. Double-click the Value Pack Installer.
    4. In the Value Pack Installer dialog box, click Data Access, and then click Install.
    5. When the Value Pack Installer is finished, click Quit.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about using Microsoft Query to retrieve external data, click the Index tab in Microsoft Excel Help, type the following text

query wizard

and then double-click the selected text to go to the "About using Microsoft Query to retrieve external data" topic.

Additional query words: XL98

Keywords: kbbug kberrmsg kbfaq KB177348


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.