Excel Calculation Query

[Jsanza]

Hi Everybody,

I am fairly new to TM1, but have been struggling with something and would appreciate any help.

I have 2 different Excel workbooks which are both saved under "Applications" on my TM1 server. Both of these workbooks contain various DBRW formulas. The problem is that when I open the one workbook, all the DBRW formulas are calculated automatically as soon as the workbook opens. The other workbook, on the other hand, does not calculate the DBRW's when the user opens up the workbook and the user first needs to press F9 before the values are calculated. I do not understand why this is happening since both of the workbooks are set to "Manual" calculation mode and this inconsistency is upsetting the users.

Can anybody perhaps explain why this is happening or suggest a solution?

Thanks

[Gabor]

Have you checked the TM1REBUILDOPTION under Excel\Formulas\Name Manager?

[Jsanza]

Thanks a lot, Gabor. It is working now, I needed to manually add the TM1REBUILDOPTION to the one sheet and assign a value of 1. I did not even know about the existence of the TM!REBUILDOPTION variable. The only thing that puzzles me though is why did that variable exist in the one sheet but for the other sheet I needed to manually create it?

[declanr]

The only thing that puzzles me though is why did that variable exist in the one sheet but for the other sheet I needed to manually create it?

As per the documentation:
http://publib.boulder.ibm.com/infocente ... PTION.html

TM1 9.4 MR1 includes a new workbook name variable, TM1REBUILDOPTION, which lets you manage calculation in workbooks containing TM1 slices and Active Forms. When you create a slice or Active Form in TM1 9.4 MR1, the TM1REBUILDOPTION name is automatically created in the corresponding Excel workbook and set to 1, indicating that all worksheets in the current workbook should be rebuilt and recalculated when a TM1 server connect event occurs.

Workbooks created prior to TM1 9.4 MR1 do not include the TM1REBUILDOPTION workbook name variable. As noted above, when the TM1REBUILDOPTION is not present in a workbook, worksheets are not rebuilt/recalculated when a server connect event occurs.

So I would assume one of your workooks harks back to yesteryear. That being said another possibility is around how you create the books in the first place, if you do a nice fancy active form button slice etc from a cubeview it should automatically create it. I have however noticed on the occasion you decide to properly create a TM1 linked workbook from scratch that (quite sensibly) it doesn't magically put it in... although I have been told by other people it on occasion does, I have my doubts and have never really thought to test it fully since I've never seriously suffered any impact.