Excel Calc Options overwritten at TM1Web

Post Reply
User avatar
Posts: 22
Joined: Wed May 11, 2016 2:16 pm
OLAP Product: IBM Cognos TM1
Version: TM1 PA 2.0
Excel Version: Excel 2013
Location: Anywhere, BR

Excel Calc Options overwritten at TM1Web

Post by rafaewolie » Tue Sep 05, 2017 3:06 pm


I changed the TM1web_Config.xml parameter UseBookRecalcSetting to true to use Excel's calculation option control.

When I Publish the perspectives that is set to Automatic calculation to an application in TM1web it seems that the AutoRecalc option is changed and the file starts to behave as a manually calculated workbook.

The other recalc parms are:

<add value="true" key="RecalcOnActivate"/>
<add value="True" key="RecalcOnDataValidationChange"/>
<add value="True" key="RecalcOnPicklistChange"/>

Am I missing something?


Post Reply