From Workbooks Mode

To insert a command into a report from Workbooks Mode:

Select the Workbook Content

Select the workbook content that you want the command linked to. The content can be a single cell, a range of cells, or a chart.

Copy the Link

Click on the Copy Link Button in the Desktop Toolbar, or select Edit | Copy Link.

Select the Paste Location

Go to Report Mode and select the spot in the report where you want the linked content to appear. The command will be added at the insertion point.

Paste the Link

There are a number of options for how the link can be pasted into the report. Each option is explained in the following table. When you select one of the options, Report Mode will become active and the command will be inserted into the report. You can access the paste options from:

The Edit | Paste Link into Report submenu.

The Paste Link Drop Down Menu. Click on the down wedge section of the Paste Link Button on the Desktop Toolbar.

To create a link with the default option for the selected content, you can click on the Paste Link Button or select Edit | Paste Link into Report.

Option * = Default		Pastes
Cell *		Pastes a cell using its row and column address.
Named Cell		Pastes a named cell using its range name. If the cell doesn't have a range name, this option is disabled.
Range *		Pastes a range using its row and column address. The command display an image of the selected range.
Named Range		Pastes a named range using its range name. The command display an image of the selected range. If the range doesn't have a range name, this option is disabled.
Word Table		Pastes a range as a Word table. Each cell in the Word table contains a Cell command referring to the appropriate cell in the linked workbook.
Chart *		Pastes a chart.