Err Msgs When Dynamic MSQuery/Microsoft Excel Links Activated

ID: Q112854


The information in this article applies to:
  • Microsoft Query for Windows, version 1.0
  • Microsoft Query for the Macintosh, version 1.0
  • Microsoft Query for Windows 95, version 2.0
  • Microsoft Excel for Windows, version 5.0
  • Microsoft Excel for the Macintosh, version 5.0
  • Microsoft Excel for Windows 95, version 7.0


SUMMARY

The steps on pages 54-55 of the Microsoft Query "User's Guide" explain how to create dynamic links between Microsoft Query and Microsoft Excel 5.0. These instructions are only partially correct. If you create dynamic links by copying the data in Microsoft Query and using the Paste Link command in Microsoft Excel, and you activate the link, linked cells will contain #REF error values, and you may receive the following error messages, depending on how you re-establish the link.

When you re-establish the link by doing the following You receive the following error message
Double-clicking the data
Cannot start the source object for this application
Re-opening the dependent sheet containing the links
Remote Data Not Accessible. Start Application 'QUERY..EXE'?
-and-
Cannot run 'QUERY..EXE'. The program or one of its components is damaged or missing."
NOTE: The Error message you receive on the Macintosh simply states "Can not find Data Source."


CAUSE

The instructions in the Microsoft Query "User's Guide" use the Paste Link DDE method to create dynamic links; this is the same method that is used with Q+E (the query tool that is available with Microsoft Excel version 4.0). The Paste Link DDE method is not the best method for creating dynamic links between Microsoft Query and Microsoft Excel 5.0.


WORKAROUND

To avoid these error messages, do not use the Paste Link command to paste data from Microsoft Query to Microsoft Excel. Instead, use the Get External Data command from the Data menu in Microsoft Excel. This method will establish a dynamic link between Microsoft Query and Microsoft Excel.

To use the Get External Data command to create a dynamic link, follow these steps:

  1. In Microsoft Excel, choose the Get External Data command from the Data menu.

    NOTE: If this command is unavailable, choose Add-Ins from the Tools menu, and select the Query Add-In check box.


  2. Select the desired data source.


  3. Construct a new query or close the Add Table dialog box and open an existing query.


  4. From the File menu, choose Return Data to Microsoft Excel.


  5. Make sure that the Keep Query Definition check box is selected when you return Data to Microsoft Excel.


To edit the query, do either of the following:
  • Double-click any cell containing the external data


  • -or-

  • From the Data menu, choose Get External Data, Edit Query.



MORE INFORMATION

You cannot use the old Paste/Link method from Query to Microsoft Word 6.0, because the Paste Link command is unavailable. To dynamically link data between Microsoft Query and Microsoft Word, use the Insert Database command instead.

When you use Q+E, a common way to dynamically exchange data with Microsoft Excel 4.0 is to copy the data from the Q+E query and use the Paste Link command to paste the data in Microsoft Excel. A dynamic link is then established between Q+E and Microsoft Excel. Double-clicking the data activates Q+E, as does re-opening the Microsoft Excel-dependent sheet and updating the remote links.


REFERENCES

"Microsoft Query User's Guide," version 5.0, pages 54-55

Additional query words:

Keywords : xlquery
Version : MACINTOSH:1.0,5.0; WINDOWS:1.0,2.0,5.0; Win95:7.0
Platform : MACINTOSH Win95 WINDOWS
Issue type :


Last Reviewed: October 26, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.