ClassFactory error in Excel

Post Reply
ps_in_atl
Posts: 12
Joined: Fri Apr 01, 2011 12:55 pm
OLAP Product: Cognos TM1
Version: 10.1.1 x64_MS Server 2008
Excel Version: Excel 2007

ClassFactory error in Excel

Post by ps_in_atl »

I have a user who just installed 9.5.1 and is getting the following error upon opening Excel (2007): "System Error &H80040111 (-2147221231). ClassFactory cannot supply requested class". It must be related to the add-in, but no idea why.

Any help?
thec0dy
Posts: 2
Joined: Tue Oct 18, 2011 7:31 pm
OLAP Product: Cognos Perspectives
Version: 9.5.1
Excel Version: 2007

Re: ClassFactory error in Excel

Post by thec0dy »

Hi,

Did you ever figure out the fix to this? I am having the same issue.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: ClassFactory error in Excel

Post by jim wood »

Have you tried the good old fall back in these situations.... re-install both (or just TM1) excel and TM1?
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
ccierpik
Posts: 16
Joined: Thu May 15, 2008 12:59 pm

Re: ClassFactory error in Excel

Post by ccierpik »

I wanted to check and see if anyone has come up with a solution for this. Everything was working fine and when working with an embedded excel file in powerpoint (no TM1 references, but I did have another workbook open with TM1) it crashed and from that point on I get the reference error message. I've uninstalled office and tm1, deleted *.exd files and nothing seems to work. I'm using Excel 2007 and TM1 9.5.1. Thanks for your help.
ParisHilton
Posts: 73
Joined: Fri Apr 23, 2010 11:35 am
OLAP Product: Tm1
Version: 9.5
Excel Version: 2007 2010

Re: ClassFactory error in Excel

Post by ParisHilton »

Hi , what version of windows are you using?

We've had a recent problem where a windows 7 update has caused nasties.


P
xx
“The way I see it, you should live everyday like its your birthday”


TM1 9.5 Cognos BI 8.4 Excel 2007. 128GB Ram. E7450@2.40Ghz -24 core. Fluffy white dog.
ccierpik
Posts: 16
Joined: Thu May 15, 2008 12:59 pm

Re: ClassFactory error in Excel

Post by ccierpik »

It's Vista. I finally got it to work after reinstalling Excel and TM1 and then copying in MSComCtl.ocx. I had tried that before, but I guess I just needed to do a clean install first.
Post Reply