Reference Variables in an Excel Object

In an Excel object in CDM, you can reference source-destination variables and named range variables that you have defined in other Excel objects.

Reference a Source-Destination Variable in an Excel Object

In an Excel object in CDM, you can reference a source-destination variable from a different Excel object.

In the source Excel object, you must have defined a source report object variable.

1. Open the report that you want to work with.
2. Open and check out the Excel object that you want to edit.
3. Click the Section View Mode icon in the status bar.
4. Position the pointer in a cell outside of any range variables (that is, ##RS and ##RE or ##IRS and ##IRE).
5. Click the Report Object tab on the ribbon, then click Insert Variable > Source-Destination. The Reference Variables window opens, displaying all destination (##D<varname>) and global destination (##GD<varname>) variables that have a corresponding source (##S<varname> or ##GSD<varname>) variable defined in CDM.
6. Select the destination variable you want to use and click Insert. The destination variable is inserted into the Excel object.
7. Save your changes to the Excel object. The data defined in the value of the source variable is copied into it.
8. Click the Default View Mode icon in the status bar.
9. Save your changes to the report and check in the Excel object.

Reference a Named Range Variable in an Excel Object

In an Excel object in CDM, you can reference a named range from a different Excel object.

In the source Excel object, you must have defined a source named range variable for a cell range.

1. Open the report that you want to work with.
2. Open and check out the Excel object that you want to edit.
3. Click the Section View Mode icon in the status bar.
4. Click the Report Object tab on the ribbon, then click Insert Variable > Named Range. The Reference Variables window opens, displaying all destination named range (##D<varname>) and global destination named range (##GD<varname>) variables that have a corresponding source named range (##S<varname> or ##GSD<varname>) variable in CDM.
5. Select the destination named range variable you want to use and perform one of the following actions:
   • Position the pointer in a cell outside of any range variables (that is, ##RS and ##RE or ##IRS and ##IRE). Click Insert on new worksheet. The destination named range variable is inserted into the Excel object. When you save the Excel object, a new worksheet is created and named after the name range. All data defined in the named range is copied into this new worksheet, starting at cell A1. Formatting is not copied.
   • Position the pointer in a cell outside of any range variables (that is, ##RS and ##RE or ##IRS and ##IRE). Use the Insert on new worksheet drop-down menu to select Insert on selected worksheet. The destination named range variable is inserted into the cell you selected in the Excel object (for example, B3), with the location of the content set to the cell one row below (for example, C3). In the third column, modify the value to specify the location and formatting of the content. For example, Sheet1!B3*, where Sheet1 is the worksheet name, B3 is the starting cell to copy the content to, and the asterisk (*) means that both the data and formatting is copied.
6. Save your changes to the Excel object. The data defined by the source named range variable is copied into it.
7. Click the Default View Mode icon in the status bar.
8. Save your changes to the report and check in the Excel object.