Since 9.4MR1, a new workbook recalculation variables TM1REBUILDOPTION has been introduced. Not sure this is the cause of my problem below (pretty sure it is)
In Excel 2007, we can no longer switch off Auto calculation as soon as TM1 add-in is loaded. Even when we save the slice as manual mode, the next time when we open it up again, Excel will switch back to Auto calculation. This is really killing all the existing TM1 slices.
In the 9.4MR1 release guide, it mentioned that in order to disable the auto recalculate, we have to set the workbook variable to 0 for ALL THE SLICES....
Anyone has a better suggestion or comment? Or can confirm this is the cause ?
TM1REBUILDOPTION problem
-
BBrockman
- Posts: 2
- Joined: Mon Nov 02, 2009 9:30 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
Re: TM1REBUILDOPTION problem
Yes the TM1REBUILDOPTION is a named range found in active forms, setting this =0 will turn off the auto calculation function and prevent the entrie workbook from calculating when open.
-
kangkc
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: TM1REBUILDOPTION problem
Thanks.
For classic pre-9.4 slices, this new workbook variable is not defined, the auto-calculation is switched on regardless of whether the workbook was saved as manual or auto calculation mode. Everytime we fire up Excel 2007 with tm1p.xla, it will always switch to Auto calculation mode. This is under Excel 2007
Interesting thing is we don't seems to see the same issue with Excel 2003. Workbook once saved as manual calculation, it will maintain as manual mode. Frankly I do not know whether this is a 2007 issues or a TM1 9.4MR1 + Excel 2007 issue. From the release guide, it seems to be a NEW 9.4MR1 design approach but we simply can't explain the Excel 2003 observation. Any suggestion?
For classic pre-9.4 slices, this new workbook variable is not defined, the auto-calculation is switched on regardless of whether the workbook was saved as manual or auto calculation mode. Everytime we fire up Excel 2007 with tm1p.xla, it will always switch to Auto calculation mode. This is under Excel 2007
Interesting thing is we don't seems to see the same issue with Excel 2003. Workbook once saved as manual calculation, it will maintain as manual mode. Frankly I do not know whether this is a 2007 issues or a TM1 9.4MR1 + Excel 2007 issue. From the release guide, it seems to be a NEW 9.4MR1 design approach but we simply can't explain the Excel 2003 observation. Any suggestion?