TM1 Forum

We have a report on TM1web with a button that opens a websheet. The workbook has with 5 worksheets.

When the report is run for the first time after the tm1web is started up, the worksheet opens and shows the correct number (5) of worksheets.

When the report is opened a second time, the websheet opens but now shows 10 worksheets. When the websheet is opened a third time, it has 15 worksheets, etc, etc.

Only when the web instance is restarted, does the websheet revert back to only 5 worksheets.

Any ideas how to stop the worksheets being duplicated?

Just to clarify on a few things:

1. What does the button do?
2. When a websheet is opened, does it open in tm1web?
3. Does it store a counter, or update a subset as part of a process that action button triggers?
4. Does the original websheet contains the 5 worksheets? or does it get generated as part of the action button.