#NAME? appears when importing sd file in JChem for Excel

When I import an sd file into JChem for Excel the string #NAME? appears in the cell along with the structures.  Please advise how to correct this.

Hi, please let us know a version mumber?

Viktor

version 5.10.0.673.  Thank you

Please try out this:

https://www.chemaxon.com/jchem4excel/adminguide/name__in_cell.html

We managed to introduce a workaround to this (Micrososft) issue:

http://www.chemaxon.com/jchem4excel/changes/changes.html#V113 please see it in the release notes.

JChem for Excel 5.11.5 (906)

Viktor

Reinstallation worked.  Thank you Viktor

When exporting data from IJC or importing an sdfile in JChem for Excel #NAME? is still appearing in with the structure.  I am on Windows7 and have JChem for Excel verison 6.3.1.1807

Hi Mark,

thanks for short meeting, Automation functions are available in the Office menu / Addins / Excel-addins / Go.

Since 6.1 we have had two functions:

• JCFunctions containing
  - On-line help for each chemical function, 
  - it provides chemical categories to find the most appropriate function for your current workflow


• JChemExcel Functions containing the native functions including drawing functions

the #Name is caused by the JChemExcel function mostly if it is not checked/piped among automations.

 

• JCFunctions is an XLA in the Excel installation folder you need to Browse


• JChemExcel Functions is a COM dll you need to add clicking on the Automation button and select amog the installed COM classes as 

we did on the screen share meeting.

This is tha way how Microsoft recommend for the users to customize their Excel addin functions.