ChemDraw for Excel: Add-In is not loading in Excel

ChemDraw for Excel add-In is not loading in Excel.

NOTE: ChemDraw for Excel is included with Signals ChemDraw and ChemDraw Professional products. It is not included with ChemDraw Prime.

If you are using ChemDraw version 25 or later, you need to make sure you have used the second installer for ChemDraw Applications in addition to the ChemDraw installer.  

The ChemDraw installer only adds the ChemDraw application, which does not include ChemDraw for Excel.

If you are using Signals ChemDraw or ChemDraw Professional, the supported Hardware and Software requirements, and ChemDraw for Excel add-in is not working/loading, any of the solutions below may resolve the issue. You may need to request help from your IT group to re-install the software and make registry changes.

1. Check Add-ins setting in Microsoft Excel application.
   a) Go to File – More – Options – Add-ins – Manage - Disabled Items from the drop-down menu to check if ChemDraw for Excel add-in is not disabled.
   b) If enabled, select ‘Excel Add-ins’ from drop-down menu and make sure ‘ChemDraw for Excel ’ and ‘ChemDrawExcel Functions' are checked.
   c) If checked, select Com add-ins from the drop-down menu and make sure ChemDraw/Excel in Com add-ins is checked.
   d) Check if ChemDraw for Excel add-in loads or not.

2. Open MS Excel and click on File > Options > Trust Center > Trust Center Settings

   Click the Add-ins option on the left-side menu and make sure the "Required Application Add-in to be signed by Trusted Publisher" is not checked. If it is, remove the check mark, click OK and restart MS Excel.
   
   

3. Check if the Load behavior of ChemDraw for Excel add-in is set to 3 in registry following steps below.
   a) Right click on Start menu – Run – Type Regedit – Click Ok.
   b) Browse the location below 
   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins\ChemDrawExcelAddIn20.ExcelAddIn
   c) Click on the Load Behaviour to see the Value Data there. If it is 0,1 Or 2, change it to 3.
   d) Click Ok and launch Microsoft Excel to see if ChemDraw for Excel add-in loads or not.
4. Try launching Microsoft Excel as an admin by going to Start menu – Excel – Right click – More Options – Run as Administrator.
5. Check if ChemDraw for Excel add-in and Microsoft Excel is added in the Exclusion list of the antivirus program you are using. Some of the antivirus programs block the function of add-ins in Microsoft Excel. If you require assistance in adding ChemDraw to the exclusion list, please check with your antivirus support team.
6. If all above does not work, re-install ChemDraw Suite on your machine using the steps below.
   a) Uninstall ChemDraw from Program and Features in Control Panel. You will need to uninstall any application listed for PerkinElmer or Revvity ChemDraw
   b) Delete the "PerkinElmerInformatics" and or the "RevvitySignalsSoftware" Folders from Program Files and Program Data of your machine if they exist.
   c) Delete the following registry locations by right click and click on delete. To go to registry, right click on Start menu - Run and type Regedit – Click Ok.
   HKEY_LOCAL_MACHINE\SOFTWARE\PerkinElmerInformatics
   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\PerkinElmerInformatics
   HKEY_CURRENT_USER\Software\PerkinElmerInformatics
   HKEY_LOCAL_MACHINE\SOFTWARE\RevvitySignalsSoftware
   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\RevvitySignalsSoftware
   HKEY_CURRENT_USER\Software\RevvitySignalsSoftware
   
   d) Delete ChemDrawExcelAddIn12.ExcelAddIn to ChemDrawExcelAddIn 22.ExcelAddIn from the below registry location.
   HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins
   e) Restart the machine.
   f) Install ChemDraw Suite logged on to the machine as a user having full admin rights and launch Microsoft Excel to see if ChemDraw for Excel add-in loads.
7. If still ChemDraw for Excel add-in fails to load or is not working, try the following steps below. You will need IT admin privileges to perform the following steps:
   a) Uninstall the ChemDraw Program using step 6 mentioned above.
   b) Uninstall Microsoft Office from your machine by going to Control Panel – Program and Features.
   c) Restart the machine.
   d) Reinstall Microsoft Office.
   e) Reinstall Signals ChemDraw or  ChemDraw Professional.