Replace Current Workbook option

The Replace Current Workbook option determines whether the target worksheet is opened in a new window or in the same window, replacing the source worksheet.

The Replace Current Workbook option is displayed on the Navigate tab of the Action button properties dialog box.

For example:
  • If Replace Current Workbook is not selected (default) and you are working in TM1® Web, then the source worksheet remains open and the target worksheet opens in a new tab.
  • If Replace Current Workbook is selected and you are working in TM1 Web, then the source worksheet is replaced by the target worksheet on the same tab and a new tab does not open.
Important: If you enable the Replace Current Workbook option, remember to save your workbook before you test the new button. You could lose your changes if you click the button and cause the current workbook to close.