Attempts to start TM1 Perspectives fail with an error message.
May see one of two errors:
Microsoft Visual Basic for Applications
Object library invalid or contain references to object definitions that could not be found
Microsoft Visual Basic
Compile error in hidden module: MenuFuncs
The cause of the error may be related to Microsoft updates having been applied, but may have other root causes as well. The result is that the .EXD files become corrupt and TM1 does not know how to handle them, and therefore, throws the error.
The errors have been seen on various versions of TM1/Cognos Express and with Excel 2007/Excel 2010.
Resolving The Problem
When using Windows 7, use a file manager like Windows Explorer to go into the user specific directory "%AppData%\Roaming\Microsoft\Forms\" and delete the EXD files "RefEdit.exd" and "MSComctlLib.exd", then restart TM1 Perspectives.
When using Windows XP, use a file manager like Windows Explorer to go into the user specific directory "%AppData%\Microsoft\Forms\" and delete the EXD files "RefEdit.exd" and "MSComctlLib.exd", then restart TM1 Perspectives.
For detailed information on corrupt EXD files and how to deal with them see the Microsoft KB article 290537: "EXD files are created when you insert controls".
For more information on the differences between Windows XP and Windows 7 regarding the directories referred to by environment variables like %AppData% see the Microsoft TechNet Library document: "Managing Roaming User Data Deployment Guide"
15 June 2018