The information in this article applies to:
SYMPTOMSWhen you run Microsoft Query from Microsoft Excel and you switch from Query back to Excel, your computer appears to stop responding (hang). CAUSEThis problem may occur when the following conditions are true:
-and- WORKAROUNDTo work around this problem, press the ESC key when the computer appears to stop responding. If this does not work the first time, try pressing ESC multiple times. When your computer responds to the ESC key, you receive the following message: When this dialog box appears, click OK. After you return to Excel, Microsoft Query is active, but it does not return any data to Microsoft Excel. Before you run another query, switch to Microsoft Query by clicking the Query icon on the Application menu. In Microsoft Query, click Cancel in the Choose Data Source dialog box, and then click Quit on the File menu. After you close Query, return to Excel and perform another query. NOTE: If the Microsoft Office Manager is installed, you can also press COMMAND+TAB to switch to Microsoft Query. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. REFERENCESFor more information about Microsoft Query, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text Microsoft Query, overviewand then click Show Topics. Select the "About using Microsoft Query to retrieve external data" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant. Additional query words: XL98 hang hung msquery external
Keywords : kbdta xlquery xlgpf |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |