Excel recalculation

[K Vuong]

Hi,

Does anyone know how to stop Excel recalculating after one logs onto the TM1 server?
It seems that even though we have Auto recalc off, when you have (often large) speadsheet open and then log onto TM1 server, Excel just recalculates.

Is there anyway to turn this off as I am sure this did not happen in all the other TM1 version I have worked with.

Excel is 2003 SP3 published on Citrix
TM19.4

TIA
Ken

[dubs]

Look for the TM1REBUILDOPTION in Names and set it to 0 instead of 1:

http://forums.olapforums.com/viewtopic. ... erformance

[K Vuong]

You are a star Dubs, that's worked a treat. Than you.

Cheers,
Ken

[dubs]

no probs, and thanks to aklante for first pointing it out

[Gregor Koch]

Hi
Just adding to the TM1REBUILDOPTION in Active Forms.

You can prevent that the TM1REBUILDOPTION is set to '1' by default by setting

TM1RebuildDefault = F

in your tm1p.ini file.
The named range will still be created but at least you don't have to go in every time and change it to '0' when you work with Active Forms.

Cheers

[dubs]

Gregor, is that what the value refers to? I did wonder as I was only looking at that last week - nice spot!!

[Gregor Koch]

Yes, it does. Thanks.