How to prevent Active Form File Load Refresh

Post Reply
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

How to prevent Active Form File Load Refresh

Post by Ashleigh W »

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.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: How to prevent Active Form File Load Refresh

Post by gtonkin »

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.
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: How to prevent Active Form File Load Refresh

Post by Ashleigh W »

thank you for quick answer. I'll try and get back.
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: How to prevent Active Form File Load Refresh

Post by Ashleigh W »

Works perfect. Thank you gtonkin
Post Reply