IBM Support

Unable to load TM1 Perspectives: Microsoft Visual Basic Automation error

Troubleshooting


Problem

Trying to load TM1 Perspectives with Excel results in an error. Opening Excel on its own, does not give an error.

Symptom

English error:

Microsoft Visual Basic
Automation error
Unspecified error

German error:


Microsoft Visual Basic
Automatisierungsfehler
Unbekannter Fehler

Resolving The Problem

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 this does not resolve the problem, also see technote 1593238 (link below)

Related Information

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Perspectives","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5.2;9.5.1;9.4 MR1;10.1.0;10.1.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21438688