Error loading 10.1 add-in to Excel 2010

Post Reply
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Error loading 10.1 add-in to Excel 2010

Post by Martin Ryan »

My colleague has just uninstalled 9.5.2 and installed 10.1 on his local machine, for which he has admin rights. Now when he tries to open the add-in he gets this error:
addinerror.JPG
addinerror.JPG (12.58 KiB) Viewed 4074 times
Any ideas? I figure it relates to trying to load the dlls, so I tried updating the Path variable (it seems 10.1 doesn't update this automatically and the install location has moved from previous versions) but that didn't help.
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Alan Kirk
Site Admin
Posts: 6667
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: Error loading 10.1 add-in to Excel 2010

Post by Alan Kirk »

Martin Ryan wrote:My colleague has just uninstalled 9.5.2 and installed 10.1 on his local machine, for which he has admin rights. Now when he tries to open the add-in he gets this error:

Any ideas? I figure it relates to trying to load the dlls, so I tried updating the Path variable (it seems 10.1 doesn't update this automatically
Unlike programs which cost a fraction of the amount that TM1 does, but I made this point rather bluntly to IBM in the past. But then, they can automatically update older versions, too...
Martin Ryan wrote: and the install location has moved from previous versions) but that didn't help.
I smell an .exd file issue again. Try cleaning out those and see whether that helps.
"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.
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: Error loading 10.1 add-in to Excel 2010

Post by Harvey »

I had an issue that looks like it might have a similar cause.

Google took me to the IBM website where it said that Excel 2010 64-bit is NOT supported by the add-in. It advised that I should remove that and install the 32-bit version.

Kinda funny for a 64-bit application! Heck, CX is 64-bit only, so I reckon there will be a lot of frustrated users with 64-bit MS Office who are unable to run Xcelerator!

Sorry, for some reason I am unable to find the link to the IBM docs, but this happened a couple of days ago, so my memory is fresh on the issue.
Take your TM1 experience to the next level - TM1Innovators.net
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Error loading 10.1 add-in to Excel 2010

Post by jameswebber »

Agree that CE only supports 32 bit Office 2010 http://www-01.ibm.com/support/docview.w ... wg27024128

But I believe this issue is related to a windows update http://www-01.ibm.com/support/docview.w ... RXT&mync=R

Try removing the 10.1 client completely installing Microsoft Visual C++ 2005 Redistributable (I needed the SP1 version)
http://www.microsoft.com/en-us/download ... px?id=5638

Then reinstall the 10.1 client
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Error loading 10.1 add-in to Excel 2010

Post by Martin Ryan »

No such luck on any of those options. I guess he'll just have to use Citrix like everyone else. Thanks for the suggestions guys.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Alan Kirk
Site Admin
Posts: 6667
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: Error loading 10.1 add-in to Excel 2010

Post by Alan Kirk »

Martin Ryan wrote:No such luck on any of those options. I guess he'll just have to use Citrix like everyone else. Thanks for the suggestions guys.
Did you also see this recent thread? (Well, the later posts are recent and so is the IBM link.)
"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.
User avatar
jameswebber
Community Contributor
Posts: 188
Joined: Sun Nov 21, 2010 8:00 pm
OLAP Product: Cognos Express 10
Version: CE 10.1.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Error loading 10.1 add-in to Excel 2010

Post by jameswebber »

Or what about Office 2010 SP1 as per this http://www-01.ibm.com/support/docview.w ... wg21438688?
Post Reply