All,
When we open excel2010 with TM1v9.0 add-ins, we get this error.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/sprea ... /2006/main">
<logFileName>error040760_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Program Files\Applix\bin\tm1.xla'</summary>
- <additionalInfo>
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</additionalInfo>
</recoveryLog>
Does anyone have any ideas on how to correct this?
Error in tm1.xla in Excel2010
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: Error in tm1.xla in Excel2010
No current version of TM1 is supported with Excel 2010. Excel 2007 is supported with 9.4 or later, though earlier versions could be made to work with errors.
- Steve Vincent
- Site Admin
- Posts: 1054
- Joined: Mon May 12, 2008 8:33 am
- OLAP Product: TM1
- Version: 10.2.2 FP1
- Excel Version: 2010
- Location: UK
Re: Error in tm1.xla in Excel2010
support information for 9.5.1 http://www-01.ibm.com/support/docview.w ... wg27018895
support information for 9.0.x http://www-01.ibm.com/support/docview.w ... wg27014170
support information for 9.0.x http://www-01.ibm.com/support/docview.w ... wg27014170
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: Error in tm1.xla in Excel2010
I am getting the same error in Excel 2007 and TM1 9.4 MR1.
Any clues?
Any clues?
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- Posts: 47
- Joined: Tue Mar 09, 2010 6:40 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2003
Re: Error in tm1.xla in Excel2010
This error typically occurs when VBA is disabled or not installed.
If you start Excel fresh (without any add-ins), can you access/start the Visual Basic Editor (Tools > Macro > Visual Basic Editor)? If not, then the cause of the problem is either:
a) the "VBA" installation setting was set to "Not Available" when you installed Excel OR
b) the "Disable VBA for Office Applications" system policy is in effect.
Try this and let us know
If you start Excel fresh (without any add-ins), can you access/start the Visual Basic Editor (Tools > Macro > Visual Basic Editor)? If not, then the cause of the problem is either:
a) the "VBA" installation setting was set to "Not Available" when you installed Excel OR
b) the "Disable VBA for Office Applications" system policy is in effect.
Try this and let us know
-
- Posts: 136
- Joined: Tue Aug 10, 2010 5:40 pm
- OLAP Product: Planning Analytics
- Version: 2.0
- Excel Version: EXCEL 2013
Re: Error in tm1.xla in Excel2010 - Excel 2007
Hi,
I am getting the same error in Excel 2007-
Yes, I read the last message- And I went to see if Visual Basic (or Macros) is available - and the answer is NO-
I dont know what to do next- Do I ask (to my IT dpt) to have the Visual Basic allowed?
I am getting the same error in Excel 2007-
Yes, I read the last message- And I went to see if Visual Basic (or Macros) is available - and the answer is NO-
I dont know what to do next- Do I ask (to my IT dpt) to have the Visual Basic allowed?
Thanks
Micheline
Micheline