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.
How to prevent Active Form File Load Refresh
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
- 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
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.
If this is happening on TM1 Web, there are other avenues that need to be explored.
-
- 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
thank you for quick answer. I'll try and get back.
-
- 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
Works perfect. Thank you gtonkin