Cogenesis Logo

National IT Support for your business (Sydney, Brisbane, Melbourne, Perth)

National Local Call: 1300 88 35 99
Level 13, 155 Castlereagh St, Sydney, NSW 2000

articles

IBM Cognos TM1 Automation Error

Steps to resolve issue for Excel 2003:

 

– Stop the “Tm1 Excel Service” service (if you also have TM1Web installed locally).

– Open Excel

– Click on the Help menu

– Select Detect and Repair

**Leave the first option checked, and the 2nd option unchecked**

Once you’ve completed the above steps, close Excel and reboot your computer.

 

Steps to resolve issue for Excel 2007:

– Stop the “TM1 Excel Service” service (if you also have TM1Web installed locally).

– Click the Microsoft Office Button

– Click “Excel Options”

– Click Resources

– Click Diagnose

– Click Continue

– Click Run Diagnostics

Once you’ve completed the above steps, close Excel and reboot your computer.

 

Steps to resolve issue for Excel 2010:

1) Please install the SP1 for Excel 2010 32-bit

a) either use the following link: http://www.microsoft.com/download/en/details.aspx?id=26622

or

b) in Excel 2010, menu “File”, “Help” and “Check for Updates”

2) After the successful installation of SP1 for Excel 2010 32-bit, please delete the temporary EXD-files from the following path:

C:\Documents and Settings\Administrator\Application Data\Microsoft\Forms

3) Execute an Excel 2010 Repair by going to “Control Panel”, “Add/Remove Programs”, highlight “Microsoft Office 2010”, hit button “Change” and select option “Repair”

 

If the methods above have not fixed the issue then the below must be performed.

*** Excel must be closed before performing these steps***

 

Unregister and re-register the mscomctl.ocx file.

NOTE: The following must be performed on the machine where problem is occurring when logged into the machine as a user in the local Administrators group.

 

Open a command prompt window.

When applicable (Windows Vista, Windows 7, Windows Server 2008 R2), you must use the “Run as Administrator” mode/option when opening the command prompt window

Run the appropriate commands indicated below.

 

For 64 bit machines:

regsvr32 /u C:\Windows\SysWOW64\mscomctl.ocx

regsvr32 C:\Windows\SysWOW64\mscomctl.ocx

 

For 32 bit machines:

regsvr32 /u C:\Windows\System32\mscomctl.ocx

regsvr32 C:\Windows\System32\mscomctl.ocx

 

Once the file has successfully re-registered, start Xcelerator Client to confirm whether this has resolved the problem.

Get a free IT consultation today

Contact Us Today - IT Consulting Sydney

simply complete your details below and a consultant will get right back to you

Or feel free to call us on
1300 88 35 99