Page 1 of 1

Repairs to TM1P.XLA error

Posted: Fri Dec 03, 2010 6:15 pm
by ExApplix
Guys when I try to open Perspectives it gives me the following error:

This workbook has lost its VBA Project, ActiveX controls and other programmability-related features.

Also see the attached screen shot.

I am using Excel 2007, TM1 9.4.1 on windows 2003 x64.

Can someone please help me how to resolve this issue?

Re: Repairs to TM1P.XLA error

Posted: Thu Dec 30, 2010 3:29 am
by Craig Trevor
I am getting the same error. I have raised an issue with IBM, will update with response.

TM1 9.5.1 HF 11, Windows Server 2008 R2, Excel 2007

Re: Repairs to TM1P.XLA error

Posted: Thu Dec 30, 2010 6:19 am
by Craig Trevor
After much installing, reinstalling, rebooting, etc. I have identified that when we installed Excel 2007, we disabled everything else in the Office setup.

Cognos TM1 requires that you have 'Visual Basic for Applications' installed. Once this was installed, everything is working fine.