Navigate to another worksheet

You can use an action button to navigate to another worksheet in the same workbook, or to a worksheet in another workbook.

1. Create an action button. For more information, see Add to a worksheet.
2. In the Action Button Properties dialog box, click Go to another Worksheet.
   The Worksheet tab is displayed.
3. Specify the target workbook.
   • To select a workbook on a TM1® server, click TM1 Applications. Click Browse and select the workbook.

     Or, to use a cell reference or a named range for the workbook name, click . The referenced cell or named range must contain the path to the workbook. Start with the first folder name under Applications and use a back-slash \ character to separate folders. Do not include the Applications folder in the path. For example: Planning Sample\Bottom Up Input\Budget Input.

   • To select a workbook that is stored on your computer or on the network, click Files. Click Browse and select the workbook.
     Note: If you plan to share your workbook with TM1 Web or IBM® Planning Analytics Workspace users, place the target workbook in a shared network location. The location that you specify must be accessible by the server where TM1 Web or IBM Planning Analytics Workspace is running.
4. Specify the target worksheet.
   You can use any of the following techniques.

   • Click the Sheet list and select a worksheet.
   • Enter the worksheet name in the Sheet field. Use the following format: =SheetName!Cell
   • Use a cell reference or a named range, click . Specify the cell reference or a named range, and then click OK.
5. Set the following options.
   • Match Title Elements - Automatically matches and sets the text of the title dimensions in the target worksheet when a user clicks the action button. For more information, see Match Title Elements option.
   • Replace Current Workbook - Determines whether the target worksheet opens in a new window or in the same window, replacing the source worksheet. For more information, see Replace Current Workbook option.
6. Select the calculation operation that you want performed on the target worksheet.
   • Automatically Recalculate Sheet - Refreshes the data in the current worksheet.
   • Rebuild Sheet - Equivalent to Automatically Recalculate Sheet. Rebuilds the TM1 Dynamic Report to its original report definition configuration.
   • None - Do not recalculation or rebuild the worksheet.
7. To map items, click Advanced Options.
   For more information, see Map fields.
8. If you want to recalculate or rebuild the worksheet before navigating to the target worksheet, click the Calculate tab and select an option.
9. Set the appearance of the action button. For more information, see Set the appearance.
10. Click OK.