Recalculating an Active Form

You can update data values in both the current form and the current Excel worksheet by following the steps below:

• To update data values in the current form:

  Click F9 to update data values in the current form configuration.

• To update data values in the current Excel worksheet:
  1. Right-click an Active Form cell.
  2. Click Active Form, then click Rebuild Current Sheet to rebuild the Active Forms in the current Excel worksheet.

     Any temporary configuration modifications you have applied to the forms will be discarded and the forms will revert to their most recent saved state. You can also press ALT+F9 to rebuild the current sheet.

• To update data values in all Excel worksheets:
  1. Right-click an Active Form cell.
  2. Click Active Form, then click Rebuild Current Book to rebuild all Active Forms in all worksheet in the current Excel worksheet.

     Any temporary configuration modifications you have applied to the forms will be discarded and the forms will revert to their most recent saved state.

You can control the default behavior of recalculating Active Forms using the TM1Rebuild and TM1RebuildDefault configuration parameters. See the IBM® Cognos® TM1® Installation and Configuration Guide for more information.