Recalculate or rebuild a worksheet

You can use an action button to recalculate or rebuild a worksheet, without running a TurboIntegrator process or navigating to a new worksheet. You can also use the Calculate tab to select the calculation operation that you want the action button to perform before running a TurboIntegrator process or navigating to another worksheet.

1. Create an action button. For more information, see Add to a worksheet.
2. In the Action Button Properties dialog box, click Precalculation.
3. Select the calculation option that you want to use.
   • Automatically recalculate sheet - Refreshes the data in the current worksheet.
     Note: The Automatically Recalculate Sheet option does not refreshExploration Views or Quick Reports.
   • Rebuild sheet - Rebuilds the TM1® Dynamic Report to its original report definition configuration.
4. Click Done.