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.

The CLSID of ChemAxon.JChemExcel.NetAxCtrls.TaskPaneHost is not registered

Create a .reg file with the following content: and run it:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\CLSID\{1DF50062-D71A-3607-8B4F-17B51D2DB0C1}]
@="ChemAxon.JChemExcel.NetAxCtrls.TaskPaneHost"

[HKEY_CLASSES_ROOT\CLSID\{1DF50062-D71A-3607-8B4F-17B51D2DB0C1}\Implemented Categories]

[HKEY_CLASSES_ROOT\CLSID\{1DF50062-D71A-3607-8B4F-17B51D2DB0C1}\Implemented Categories\{62C8FE65-4EBB-45E7-B440-6E39B2CDBF29}]

[HKEY_CLASSES_ROOT\CLSID\{1DF50062-D71A-3607-8B4F-17B51D2DB0C1}\InprocServer32]
"Class"="ChemAxon.JChemExcel.NetAxCtrls.TaskPaneHost"
"CodeBase"="file:///C:\\Program Files\\ChemAxon\\JChem for Excel\\JChemExcel.NetAxCtrls.dll"
"Assembly"="JChemExcel.NetAxCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d25ce09139c726a9"
"RuntimeVersion"="v2.0.50727"
"ThreadingModel"="Both"
@="mscoree.dll"

[HKEY_CLASSES_ROOT\CLSID\{1DF50062-D71A-3607-8B4F-17B51D2DB0C1}\InprocServer32\1.0.0.0]
"Assembly"="JChemExcel.NetAxCtrls, Version=1.0.0.0, Culture=neutral, PublicKeyToken=d25ce09139c726a9"
"RuntimeVersion"="v2.0.50727"
"Class"="ChemAxon.JChemExcel.NetAxCtrls.TaskPaneHost"
"CodeBase"="file:///C:\\Program Files\\ChemAxon\\JChem for Excel\\JChemExcel.NetAxCtrls.dll"

[HKEY_CLASSES_ROOT\CLSID\{1DF50062-D71A-3607-8B4F-17B51D2DB0C1}\ProgId]
@="ChemAxon.JChemExcel.NetAxCtrls.TaskPaneHost"

In Case another Version of JChem for Office is already Installed on the Computer

It can cause issues, if there are two versions of JChem for Office are installed on the same computer, so the JChem for Office installer controls this and throws an error message, which informs the user that:

"There is another version of JChem for Office installed on your computer. Please uninstall this version before installing the current one!"

In this case, please check in "Control Panel/Programs and Features" if JChem for Office is listed among installed applications. If it is not there, it means that your Windows registry has become corrupted for some reasons, eg. an interrupted installation because of a powerbreak, any unexpected shutdown of your computer, or send your Windows into "Sleep" mode while install is in progress or any aborted, failed JChem for Office install happened in the past.

Please keep in mind that it is strongly advised to wait for the complete installation process of JChem for Office, or if you hit Cancel, please wait until the rollback process is completed, because incomplete, interrupted installation may also result in registry corruption.

Registry Repair Process

The simplest way to do the registry repair is to go to "Settings/Recovery" and press "Get started":

images/attachment.freshdesk.com/inline/attachment.gif

Unable to Construct the Marvin Editor Control error message

Because of recent Windows 10 updates in Office 2016, 2019 or Office 365 , when you press the Add/Edit ribbon button in the JChem ribbon, with default Microsoft Office settings you will receive this error message:

images/download/attachments/1806944/image2020-5-22_10-19-54.png

The solution is the following:

  1. Go fo File/Options/General menu.

  2. Change the default option: "Optimize for best appearance" to "Optimize for compatibility"

  3. Please note that you have to restart the application.

images/download/attachments/1806944/image2020-5-22_10-21-1.png