Troubleshooting
Problem
After receiving a Microsoft update(s), users trying to access TM1 Perspectives see the following error message:
Symptom
Microsoft Visual Basic
Automation Error
Unspecified Error
Cause
The following Microsoft updates have been released August 2012.
See bulletin below for all updates released;
http://technet.microsoft.com/en-us/security/bulletin/ms12-aug
This issue is specific to this Microsoft Office security Update KB2687441
Environment
Excel 2007 on Windows
Resolving The Problem
*** 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 Perspectives to confirm whether this has resolved the problem.
For additional information including for other Operating system and Excel versions, please see the following Technote:
http://www-01.ibm.com/support/docview.wss?uid=swg21438688
OR
Upgrade to Office 2010
Document Information
Modified date:
15 June 2018
UID
swg21608271