Cannot load TM1 perspective into Microsoft Excel 2010

Product:Cognos TM1 10.1.1 PerspectivePLANANALYTICS_Update_version=PLANANALYTICS-AW64-ML-RTM-10.1.7101.108-0Windows 2008 R2 serverMicrosoft Office 2010 32 bit version 14.0.6023.1000
Symptom:When you start TM1 perspective on a new computer you get a error message, and can not load TM1 perspective into Microsoft Excel 2010.
Error Message:Could not load an object because it is not available on this machine.
Compile error in hidden module: MenuFuncs.This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click "Help" for information on how to correct this error.

Solution:Find the correct MSCOMCTL.OCX file from a different computer, where TM1 perspective is working with Microsoft Excel 2010.
Correct version is dated 2012-06-06 8:49 AM and 1046 KB in size.File version version 6.01.9834
On the computer where you have the problem.Exit ExcelGo to folder %systemroot%\sysWOW64Rename file mscomctl.ocx to mscomctl.ocx.old.txtCopy the correct mscomctl.ocx fil to folder c:\windows\syswow64Start a cmd prompt with "run as administrator"Enter cd %systemroot%Enter cd syswow64Enter regsvr32 /u mscomctl.ocxClick OK on dialogEnter regsvr32 mscomctl.ocxClick OK on dialog
Start Tm1 Perspective again and test.