


The MS-Excel Link menu item in the Database menu or the~
~ toolbar button opens a window showing all the MS-Excel links that are accessible to
you (see Section Linking Microsoft Excel Tables with Data). In this window, you can create and save new MS-Excel links, modify, or delete existing ones.
Initially, the window is empty and you will only be able to create new MS-Excel links. To do so, select New and describe your MS-Excel link in the following window.

First enter the name of the Microsoft Excel object (for example, a Microsoft Excel table or a macro template) to which data is to be linked. Then specify the link position. The description of the position consists of the row and column description of the top left and bottom right corner of your destination area. If the destination area is smaller than the data of a query, only as much data as fits in the destination area is transferred. If only the top left corner is specified for the description of the position or if it has not been specified at all, the data of a query will be inserted either from the top left corner or from the active cell after a warning has been displayed and confirmed.
After describing the position for a link, you can link a saved SQL statement or query to your Microsoft Excel object. You can link several SQL statements or queries to an MS-Excel object, e.g., a table. The linked SQL statements or queries are shown in tabular format with their positions within the Microsoft Excel object.
You can also insert SQL statements and queries that other users share into your MS-Excel link.

If you want to view the result of an SQL statement or query, select the corresponding SQL statement or query in the table and Execute. If you want to remove an SQL statement or a query, select Delete. If you have created all the links desired for the Microsoft Excel object, you can save it with Save. QueryPlus uses the name of the link object for saving; in this case, the name of the Microsoft Excel table. This name can have up to 150 characters.
If there are already saved MS-Excel links or if you share MS-Excel links with other users (see Section New Sharing of Stored Objects), these links are displayed, ordered by owner. Click on the title bar to order the MS-Excel links by name. In the title bar, you can see whether the MS-Excel links are ordered by owner or by name; the sort column is not enclosed in brackets.
If other users allow you to share their MS-Excel links, you can execute these links. The owner of an MS-Excel link to be shared can determine whether the sharing user may only execute the MS-Excel link or also read it. If you share an MS-Excel link for execution only, then you cannot change it. If you share it for reading, then you can modify and save it as your own MS-Excel link.


