TM1 9.0 and Excel 2007 Macro loading error

Post Reply
User avatar
damientaylorcreata
Posts: 86
Joined: Mon Apr 13, 2009 8:47 am
OLAP Product: Cognos TM1
Version: 9.4
Excel Version: 2003 and 2007
Location: Sydney, Australia
Contact:

TM1 9.0 and Excel 2007 Macro loading error

Post by damientaylorcreata »

Hi Guys,

Not sure if anybody else has experienced this problem, but I am having an issue with the TM1.xla addin with Excel 2007 only. It was fine with Excel 2003, but now if I have the addin enabled, every time Excel loads, it gives me the two errors as shown below. However when I close these error windows, the Tm1 add-in seems to work anyway, but obviously it is really slow and annoying that every time I open Excel 2007, I have click through each of these windows.

There are 2 people in our office using Tm1 add-in in Excel 2007 and both are having the same issue. I have tried reinstalling Perspectives and also reinstalled Excel 2007, but I still get the same errors.

Can anybody help?

error1.GIF
error1.GIF (10.94 KiB) Viewed 2860 times
error2.GIF
error2.GIF (11.55 KiB) Viewed 2860 times
Thanks,
Damien
Damien Taylor
Andy Key
MVP
Posts: 352
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: TM1 9.0 and Excel 2007 Macro loading error

Post by Andy Key »

Damien,

TM1 9.0 is not supported on Excel 2007. The messages you are seeing are part of the reason why.

But as you have noticed, if you dismiss these warnings TM1 seems ok.

Not the best user experience though...
Andy Key
User avatar
damientaylorcreata
Posts: 86
Joined: Mon Apr 13, 2009 8:47 am
OLAP Product: Cognos TM1
Version: 9.4
Excel Version: 2003 and 2007
Location: Sydney, Australia
Contact:

Re: TM1 9.0 and Excel 2007 Macro loading error

Post by damientaylorcreata »

Hi Andy,

Thanks for that.. I was hoping this would not be the case however.

Damien
Damien Taylor
Post Reply