System Error &H80040111 (-2147221231)

Post Reply
show75
Posts: 7
Joined: Thu Mar 07, 2013 7:23 pm
OLAP Product: oracle and sql server
Version: TM1 9
Excel Version: 2013

System Error &H80040111 (-2147221231)

Post by show75 »

Win 7 ultimate
Excel 2013
TM1 9.0 SP2
Getting the following error when launching TM1 Perspectives:
System Error &H80040111 (-2147221231)
and TM1 do not loading and work
I tried the following steps , I couldn't find files that have a .EXD extension and still getting the same error
Try the following suggestions;
1. From Windows Explorer, navigate to the following folder and delete the files that have a .EXD extension:
C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms\

Then I tried the following steps , still getting the same error
3.) Unregister OCX file

Regsvr32.exe /u C:\Windows\SysWow64\MSCOMCTL.OCX
4.) Rename the OCX file
C:\Windows\SysWow64\MSCOMCTL.OCX to
C:\Windows\SysWow64\MSCOMCTL.bak
4.) Copy a new MSCOMCTL.OCX file from another computer to the Windows\syswow64 directory.
5.) Register the new OCX file
Regsvr32.exe C:\Windows\SysWow64\MSCOMCTL.OCX

please help

thanks
User avatar
gtonkin
MVP
Posts: 1212
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: System Error &H80040111 (-2147221231)

Post by gtonkin »

try check the filesize/version of your MSCOMCTL.OCX - I have had this issue with older versions.
My current working version shows the following in the command prompt:

Code: Select all

2014/05/22  10:55 AM         1,070,232 MSCOMCTL.OCX
Unregister, replace with new and re-register. You may need to find an older version for TM1 9.0
You could also try re-registering tm1prc.dll, tm1xl.ocx and tm1dasrv.dll

Also, not sure that TM1 9.0 and Excel 2013 will actually work together.
show75
Posts: 7
Joined: Thu Mar 07, 2013 7:23 pm
OLAP Product: oracle and sql server
Version: TM1 9
Excel Version: 2013

Re: System Error &H80040111 (-2147221231)

Post by show75 »

I solved this issue by repair office 2013 ,custom installation and install vba
the TM1 now working
thanks for your effort
Post Reply