Issues Detailed

Warning Message Appears when a Workbook is Opened

"This workbook contains links to other data sources." The formula bar display formulas like this:

='C:\Program Files (x86)\ChemAxon\JChem for Excel\JCFunctions.xla'!JCIUPACName(A1)

Resolution

  1. Choose Update, you can click the Edit Links... button.

  2. The JCfunction.xla is selected, and its status is Error: Source not found.

  3. Click the Change Source... button.

  4. Now, locate the JCFunctions.xla in the folder where JChemExcel installed.

  5. Click Open.

  6. Close this dialog.

  7. Formulas should be resolved now.

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.