TM1 Forum

Hi everyone,

I googled for hours to find a solution for this problem but I couldn't find one:
As soon as you have more than one sheet in an excel file and upload, tm1web allows to navigate between the two (by using the websheet tabs).
The problem is that I navigate with ActionButtons between the sheets and don't want to allow a user navigation by using the worksheet tabs.
How can I disable that worksheet tabs are shown?

Many thanks for your help in advance!
Philipp

Hi Philip

General advice with TM1 Web is to avoid using multi-sheet workbooks. This is largely due to the time that it takes to load up the sheets.

There is an option to turn off tabs in the Web.Config file. However, I am not sure if that will work on multi-sheet workbooks, as opposed to the normal tabs, as I have never used multi-sheet workbooks in TM1 Web.

Regards

Paul Simon

Hello Phillip,

Most of our wesheets have multiple tabs. I use one of two methods to hide tabs:-

• If you want some of the tabs to be displayed, you can simply hide the ones that you don't. In Excel right-click on the tab and choose hide;
• To hide all tabs in the workbook in Excel Options - Advanced - Display options for this workbook - Un-check Show Sheet Tabs;

Thanks for your answers! That worked for me!