Error: Compile error in hidden module: commandhandler
|Knowledge Article Number||000003868|
Connect for Office displays an error message in Excel
compile error in hidden module: commandhandler
If you see the following error message upon opening MS Excel 2007, it is because the plug-in has been disabled in Microsoft Excel and is not set as trusted.
Follow the steps below to enable the Office toolbar for your Excel
1- From Microsoft Excel click on the office logo and click on 'Excel Options'
2- Click on Trust Center and click on Trust Center Settings
3- Click on Trusted Location and click on Add new location
4-Click on Browse and navigate to C:\Program Files\Microsoft Office\Office12\XLSTART and click on OK
*If you are using a 64bit version of Microsoft Windows, you would need to browse and navigate to the following folder instead C:\Program Files (x86)\Microsoft Office\Office12\XLSTART and click on OK
Note* Once you install the Connect for Office, 2 files are placed in the following folder so you need to make sure that the SFDC.xla and SFDC12.xlam exist In the …\Office12\XLSTART folder
5- Then click on okay to go back to Excel Options again
6- Now click on Add-Ins and next to the Manage drop down click on Disabled items and click on Go
7- You may see the sfdc add-ins in the Disabled items list, click on each one of them and click on Enable
8- Click on Close and close Excel