From Analysis Mode

To insert a command into a report from Analysis Mode:

Step01Select the Analysis Content

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

Step02Copy the Link

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

Step03Select 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.

Step04Paste the Link

There are a number of options for how a link can be pasted into a report. Each option is explained in the table below. You can access the paste options from:

wThe Edit | Paste Link into Report submenu.

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

To create a command 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.