"Automatic Recalculation currently on"

[Nitish]

Hi Experts,

Need your support again.

The applications (Excel Spread sheets) in TM1 web has 'Automatic Recalculation currently on' every time I load the reports. My reports takes more than 60 Secs to open up just because of default "Automatic Recalculation currently on" is always there.

I tried to fix it by updating the applications (spread sheets) again but the problem remains the same. Every time I have to turn the '"Automatic Recalculation currently on"' to 'off' manually to boost up the reports. After getting it off, my reports opens in 10 secs of time on the secont attempt.

Please advise!

Best Regards,
Nitish

[declanr]

Change the "UseBookRecalcSetting" parameter in the web.config file to true and TM1Web will take the calculation that each websheet is saved with in excel as its standard when first opened.