Excel 2007 disables automatic refreshing of formula fields..
Posted: Wed Feb 09, 2011 9:16 am
Hi
We have just upgraded a client from TM1 9.1 to 9.5.1.
We are experiencing an interesting situation and I'd like to know if you have some info on that.
Our client mainly uses Perspectives for TM1, and thus has the TM1 add in for Excel. Now what happens, if they open up ANY spreadsheet containing formulas the fields' content doesnt automatically refresh (and not only etc DBRW statements connecting to the DB - ANY calculated field).
They have to press F2 on each and every field to refresh the value. If they Save the doc, and they return into it later on, it is ok and refreshes.
Interesting - our client also has Syspro Add ins, and it does the same with that. So it sounds like a Microsoft issue?
Has anyone experienced the same issue before? All of the client stations run Windows 7
Thanx!
We have just upgraded a client from TM1 9.1 to 9.5.1.
We are experiencing an interesting situation and I'd like to know if you have some info on that.
Our client mainly uses Perspectives for TM1, and thus has the TM1 add in for Excel. Now what happens, if they open up ANY spreadsheet containing formulas the fields' content doesnt automatically refresh (and not only etc DBRW statements connecting to the DB - ANY calculated field).
They have to press F2 on each and every field to refresh the value. If they Save the doc, and they return into it later on, it is ok and refreshes.
Interesting - our client also has Syspro Add ins, and it does the same with that. So it sounds like a Microsoft issue?
Has anyone experienced the same issue before? All of the client stations run Windows 7
Thanx!