Manually Enabling JChemExcel Functions

After installing, the JChem for Excel Add-in it will be loaded automatically when starting Microsoft Excel. If any error occurs during installation, in rare cases, JChem for Excel Add-ins are not loaded automatically and have to be enabled manually.

  1. Open Excel and click File > Options.

  2. Navigate to the Add-ins tab.

    images/download/attachments/1807030/image2019-11-7_10-38-48.png
  3. Chose Excel Add-ins from the Manage drop-down list and click Go.

  4. To load an automation add-in, click Automation.

    images/download/attachments/1807030/image2019-11-7_11-32-56.png
  5. Select JChemExcel Functions from the Automation Servers dialog, then click OK.

    images/download/attachments/1807030/image2019-11-7_11-33-16.png

    To unload an automation add-in, you must remove it from the registry. Contact your system administrator for details.

From Known Issues

In Case a Function does not Work in JChem for Excel

For the proper behavior of JChem for Excel and its functions, you should have the following add-ins active (after using the first JChem action, for example, Options):

  • COM Add-ins:

    • CXNSharedAddin

    • JChemExcel JChemExcelAddin

  • Excel Add-ins:

    • Jcfunctions

    • JChemExcel Functions

Activate the CXNSharedAddin as a COM Add-in

  1. Open Excel and click File > Options.

  2. Navigate to the Add-ins tab.

  3. Chose COM Add-ins from the Manage drop-down list and click Go.

  4. Tick the checkbox next to CXNSharedAddin, and click OK.

Activate the JChemExcel Functions as an Excel Add-in

  1. Open Excel and click File > Options.

  2. Navigate to the Add-ins tab.

  3. Chose Excel Add-ins from the Manage drop-down list and click Go.

  4. Tick the checkbox next to JChemExcel Functions, and click OK.

    If the JChemExcel Functions item does not exist in the list, then click Automation, select JChemExcel Functions from the list, and click OK.

Activate the Jcfunctions as an Excel Add-in

  1. Open Excel and click File > Options.

  2. Navigate to the Add-ins tab.

  3. Chose Excel Add-ins from the Manage drop-down list and click Go.

  4. Tick the checkbox next to Jcfunctions, and click OK.

    If the Jcfunctions item does not exist in the list, then click Browse, navigate to the JCFunctions.xla file, select it and click OK.

    The file can be found in one of the following locations:

    • 32-bit: C:\Program Files (x86)\ChemAxon\JChem for Excel\JCFunctions.xla

    • 64-bit: C:\Program Files\ChemAxon\JChem for Excel\JCFunctions.xla

  5. Restart Excel.