TM1 Forum

I think I have identified the issue. Some of the users were recalcing the spreadsheets via the 'Calculate Now' option on the Excel menus, rather than by pressing F9. This makes it act as though the DBRW formula are not linked via the TM1 'View' formula, meaning it retrieves the values from the cube ...

This is with manual recalc. and tm1rebuild set to 0 for these workbooks.

I'm seeing some strange behaviour when calculating TM1 linked spreadsheets. TM1 version is 9.5.2 FP1 64bit server with same version client over both Excel 2010 and 2003. The spreadsheets are pulling values from a large cube, with daily time DIM, so are broken down into multiple feeder sheets each wi...