A link view is used to display the details about a data point in an adjacent window without disturbing the contents in the main window. Link views can be either static or dynamic.
In a static link view, the link action is predefined and details about a data point being queried are displayed in the adjacent window. Static link view behavior is already built in to Smart View.
With a dynamic link view, VBA programmers have the option to change the link behavior as required. Using the set options, you can change the row, column, POV, column information, and the connection information.
For instructions on working with dynamic link views, see:
The VBA functions related to dynamic link view:
Note: | For all of the following dynamic link view VBA functions, it is assumed that a call has already been made to HypGetSourceGrid to initialize the dynamic link query, which contains the information about the active data source and the grid on the sheet. |
When the dynamic link query has been initialized, all the subsequent setinfo, getinfo, displaytolinkview calls are performed on that saved dynamic link query. If the user changes the grid on the sheet and wants to perform the dynamic link action as per the new grid, the user must again initialize the query, using the various setinfo calls available.
Prerequisite to HypGetSourceGrid is that a connected grid must exist on the active sheet and a valid data point should be selected.