No Help Available for JChem for Excel Functions

Since version 6.0 of JChem for Excel, the Help on this function button is available for JChem for Excel functions in the Function Arguments dialog.

It is possible that the No help available notice appears in this dialog.

images/download/attachments/1807035/image2019-11-7_12-53-58.png

This can happen when the Jcfunctions Add-in is not enabled in your Excel Add-in list, some installer issues can cause this state.

To enable the add-in manually, follow the steps below:

  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.
    images/download/attachments/1807035/image2019-11-7_12-58-10.png

  5. Restart Excel, and check if the JChemExcel functions are displayed in categories (as it is described in Use Custom Chemical Functions topic).

    images/download/attachments/1807035/image2019-11-14_14-12-30.png

  6. Select the desired function, h elp is now available in Insert Function and Function Arguments dialog as well.

    images/download/attachments/1807035/image2019-11-19_9-35-23.png