Knowledge Base

Data from Query Not Returned to the Worksheet

Article ID: 115430

Article Last Modified on 8/15/2003

APPLIES TO

This article was previously published under Q115430

SYMPTOMS

In the versions of Microsoft Excel mentioned above, if you click Get External Data on the Data menu and then create a query in Microsoft Query, you may be unable to return the data to Microsoft Excel. After you click "Return Data to Microsoft Excel" on the File menu, you see the normal prompts, and an area on the sheet is selected (this area is equivalent to the number of records and fields that the query returns). However, the actual data does not appear in the Microsoft Excel sheet.

CAUSE

In Microsoft Excel, you can choose to ignore requests from other dynamic data exchange (DDE) programs by selecting the Ignore Other Applications check box. (This check box is located on the General tab in the Options dialog box). If this option is selected, you experience the symptoms described in this article.

RESOLUTION

To activate the connection between Microsoft Excel and Microsoft Query, clear the Ignore Other Applications check box. To do this, follow these steps:

  1. Click Options on the Tools menu.
  2. Click the General tab.
  3. On the General tab, clear the Ignore Other Applications check box.
  4. Click OK.


Additional query words: XL7 XL5 XL

Keywords: KB115430


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.