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?
Repairs to TM1P.XLA error
-
ExApplix
- Posts: 103
- Joined: Mon Sep 21, 2009 7:09 pm
- OLAP Product: Cognos Tm1
- Version: 10.2.2
- Excel Version: 2016
Repairs to TM1P.XLA error
- Attachments
-
- Excel error TM1P.xla
- Excel_Error_TM1P.XLA.jpg (43.36 KiB) Viewed 4474 times
Last edited by ExApplix on Thu Dec 30, 2010 5:48 am, edited 2 times in total.
-
Craig Trevor
- Posts: 7
- Joined: Tue Jul 28, 2009 4:43 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 20010
- Location: Brisbane, Australia
Re: Repairs to TM1P.XLA error
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
TM1 9.5.1 HF 11, Windows Server 2008 R2, Excel 2007
-
Craig Trevor
- Posts: 7
- Joined: Tue Jul 28, 2009 4:43 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 20010
- Location: Brisbane, Australia
Re: Repairs to TM1P.XLA error
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.
Cognos TM1 requires that you have 'Visual Basic for Applications' installed. Once this was installed, everything is working fine.