Microsoft KB Archive/115430

= Data from Query Not Returned to the Worksheet =

Article ID: 115430

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0a for Macintosh
 * Microsoft Query 2000

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.