Hello,
We are rolling out Excel 2010 soon and the TM1 Icon does not appear in the Excel menu for Excel 2010. Will there be a problem using V9.0 in Excel 2010 ?
TM1 Add In in Excel 2010
- 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: TM1 Add In in Excel 2010
In Excel 2007, TM1 uses tm1pRibbonX.xlam file to create the TM1 Menu.
Excel 2010 is not officially supported by TM1, but you might have to change something to this Ribbon file to get it working.
Excel 2010 is not officially supported by TM1, but you might have to change something to this Ribbon file to get it working.
Cheers!
Rizwan Kaif
Rizwan Kaif
- 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: TM1 Add In in Excel 2010
[*]9.0 is out of support with IBM and has been since the end of 2009 > http://www-01.ibm.com/support/docview.w ... cognos_tm1
As such they have removed any documentation for 9.0 but i know from some recent testing that there are some issues with 9.0 and Excel 2007, so the chances of it working corrcetly with Excel 2010 are minimal. Stick to what they support, don't upgrade to 2010 until they support it officially and in the mean time upgrade 9.0 to (in my opinion) at least 9.4.
As such they have removed any documentation for 9.0 but i know from some recent testing that there are some issues with 9.0 and Excel 2007, so the chances of it working corrcetly with Excel 2010 are minimal. Stick to what they support, don't upgrade to 2010 until they support it officially and in the mean time upgrade 9.0 to (in my opinion) at least 9.4.
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
- Alan Kirk
- Site Admin
- Posts: 6606
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TM1 Add In in Excel 2010
Steve, that's not the case. It was going to be the case, but it was extended for a year. 9.0 support expires at the end of this year. Check the link; the date has been updated.Steve Vincent wrote:[*]9.0 is out of support with IBM and has been since the end of 2009 > http://www-01.ibm.com/support/docview.w ... cognos_tm1
Not yet; I put a link to the documentation downloads for the various versions into the FAQ last weekend, including 9.0's. (It wasn't a "formal" update of the FAQ so no notice has been sent.)Steve Vincent wrote:As such they have removed any documentation for 9.0
Agreed completely. (About not upgrading until Excel 2010 is supported anyway. "Hold onto 9.0 until grim death" is what my 32 bit self thinks, though.)Steve Vincent wrote:but i know from some recent testing that there are some issues with 9.0 and Excel 2007, so the chances of it working corrcetly with Excel 2010 are minimal. Stick to what they support, don't upgrade to 2010 until they support it officially and in the mean time upgrade 9.0 to (in my opinion) at least 9.4.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: TM1 Add In in Excel 2010
Alan,
Thanks for the input Alan.The company is upgrading to Excel2010 because of Sharepoint which is used more widely than TM1.
Thanks for the input Alan.The company is upgrading to Excel2010 because of Sharepoint which is used more widely than TM1.
- 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: TM1 Add In in Excel 2010
oops thanks Alan, i got caught out by the table being split between cognos / applix and never saw the stuff at the bottom. that change has never officially been communicated to us tho, not that i'm surprised.
RE: sharepoint - our mob are upgrading to Office 2007 and one of their enhancements is the ability to use sharepoint with it. is it a mandatory upgrade to O2010 because of this, or just a "well its new we should probably upgrade" decision? our IT is so complex that they cannot change one thing if it has an effect on another, although TM1 useage is still reletively small here its still critical to some areas, so they have to take everything in to account, not just one piece of software.
RE: sharepoint - our mob are upgrading to Office 2007 and one of their enhancements is the ability to use sharepoint with it. is it a mandatory upgrade to O2010 because of this, or just a "well its new we should probably upgrade" decision? our IT is so complex that they cannot change one thing if it has an effect on another, although TM1 useage is still reletively small here its still critical to some areas, so they have to take everything in to account, not just one piece of software.
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
-
- Posts: 1
- Joined: Fri Dec 03, 2010 7:33 pm
- OLAP Product: TM1 Cognos
- Version: 9.4.1.3
- Excel Version: 2007
Re: TM1 Add In in Excel 2010
has anyone been able to get TM1 to work with Excel 2010 and if so what were the tricks?