TM1 in excel 2007 causes excel to crash on connect

Post Reply
jed
Posts: 62
Joined: Wed Sep 02, 2009 11:33 am
OLAP Product: TM1
Version: PA 2.0.9.4
Excel Version: 2016
Location: Australia

TM1 in excel 2007 causes excel to crash on connect

Post by jed »

We have recently upgraded to Excel 2007 and are having some issues with getting TM1 to work.

For all users that previously ran perspectives in excel 2003 I delete the tm1p.ini file then start up excel 2007, add the tm1 addin and specify the admin host. On this occaision we are able to select server explorer (or whatever it is called in 2007) and successfully use tm1.

After closing excel 2007 and then reopening and trying to select tm1 server explorer excel crashes everytime without failure on every machine and the only way I am able to connect again is by deleting the tm1p.ini file and starting again.

I'm sure this must be a setting in excel 2007 that I need to change but not sure what. Any ideas???

jed
Post Reply