ID: Q118657
1.00 WINDOWS kbother kbfixlist
The information in this article applies to:
When you use the Get External Data command in Microsoft Excel to link to a query in Microsoft Query, and you then cancel the query and exit Microsoft Excel, you receive a general protection (GP) fault when you exit Microsoft Query.
This error occurs when you exit Microsoft Excel before you exit Microsoft Query when the query that you linked to does not contain any data.
The Get External Data command is available in Microsoft Excel when you open or load the MS Query add-in file (XLQUERY.XLA). This command allows you to link to a query, update or change the query, and return the results to the worksheet in Microsoft Excel. However, if you use the Get External Data command, and you switch back to Microsoft Excel by pressing ALT+TAB or by using the Task List (CTRL+ESC), you see the hourglass displayed in Microsoft Excel. This is because of the pending DDE channel between the two applications. If you then cancel the link to the query by pressing ESC in Microsoft Excel, and you then exit Microsoft Excel, if the query does not contain any data, you receive a GP fault when you exit Microsoft Query.
The problem occurs because the DDE channel to Microsoft Query is not terminated properly in this case.
To avoid receiving a GP fault when you cancel a link to a query that is initiated by using the Get External Data command in Microsoft Excel, exit Microsoft Query before you exit Microsoft Excel.
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c for Windows.
For more information about the Microsoft Query add-in, choose the Search button in Help and type:
Microsoft Query
Additional reference words: 1.00 5.00 gpf addins dde quit err msg hang hung hour glass break interrupt
Keywords : xlquery kbfixlist
Version : 1.00
Platform : WINDOWSLast Reviewed: September 16, 1996