Print this page

Error: Compile error in hidden module: commandhandler

Knowledge Article Number 000003868
Description

Issue:

Connect for Office displays an error message in Excel

compile error in hidden module: commandhandler

 

 

Reason:

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.

 

 

 

Resolution

Resolution:

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

 

 

NEXT STEP

 

  • Make sure Microsoft Office applications are closed and then go to Control
  • In Windows XP, you click on “Add/Remove programs” or if you have Windows Vista or Windows 7, click on “Programs and Features”
  • Locate and select the “Salesforce Office Edition” and click on Uninstall
  • Now you would need to reinstall the Salesforce Office Edition.
  •  if you don’t have the installation file, you need to login to Salesforce.com and download it from Setup | Personal Setup | Desktop Integration | Connect for Office
  • Do not click on the “Install Now” button; instead download the file from the third paragraph as you see in the image below.
  • Run the setup.exe file that have downloaded for Salesforce Office Edition and finish the installation.

 

 





promote demote