Excel 2007 disables automatic refreshing of formula fields..

[Lorna]

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!

[lotsaram]

If manual calculation is enabled with Perspectives and you are seeing this kind of behaviour the most likely cause is conflict with another add-in which is also trying to take over the ActiveSheet.Calculate or Application.Calculate events.

Try disabling all other add-ins and see if this rectifies the situation.

[Lorna]

Thanx I will try that