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:
- 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.
- Select the desired data source.
- Construct a new query or close the Add Table dialog box and open an
existing query.
- From the File menu, choose Return Data to Microsoft Excel.
- 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 :