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.
   

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

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

5. Select JChemExcel Functions from the Automation Servers dialog, then click OK.
   
   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.

   {info}
   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.

   {info}
   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.