TM1 Forum

Hi everyone,

As soon as excel File Loads Active Form starts refreshing all the sheets with ActiveForm which takes time.
is there a way to prevent it from refreshing on load? I have already set the calculation mode to manual still it calculates on load.
thank you.

Have a look at the named ranges in the workbook. There should be one called TM1REBUILDOPTION. Update the value to 0 (zero). If there is not one, create it to be safe, scoped as workbook, and assign it a value of 0.
If this is happening on TM1 Web, there are other avenues that need to be explored.

thank you for quick answer. I'll try and get back.

Works perfect. Thank you gtonkin