IBM Support

Unable to load TM1 Perspectives: Microsoft Visual Basic Automation error

Technote (troubleshooting)


Problem(Abstract)

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

Technote 1593238

Document information

More support for: Cognos TM1
TM1 Perspectives

Software version: 9.5.1, 9.5.2, 9.4 MR1, 10.1.0, 10.1.1

Operating system(s): Windows

Software edition: All Editions

Reference #: 1438688

Modified date: 21 August 2012


Translate this page: