When I save an excel spreadsheet with JC4XL functions in it under 32-bit Windows and then try to open it under 64-bit Windows, I get the following error message:
"This workbook contains one or more links that cannot be updated"
I then have to click on "Edit Links..." and change the path of JCFunctions.xla from
C:\Program Files\ChemAxon\JChem for Excel
C:\Program Files (x86)\ChemAxon\JChem for Excel
Is there a way to have JC4XL check the version of Windows (32 or 64 bit) and then look for JCFunctions.xla in the appropriate folder?
This is an Excel limitation, that path is saved in the workbook, there's nothing we can do about it.
The only known way to resolve this issue, by using the 'Edit Links...', you mentioned.
Thanks for your answer. Do you think I could move/reinstall JChem in C:\Program Files\ChemAxon\JChem for Excel (instead of Program Files (x86)) and solve the problem that way, or is that not a good idea?
I never tried it. Theoretically it can work, but I consider it as an unsupported scenario.
If this is a persistent issue (creating workbooks in a machine then transferring them to another, where JChemExcel installed elsewhere) you might consider disabling the jcfunctions.xla:
- File/Options/Add-Ins, Manage Excel Add-ins, Go, uncheck 'jcfunctions'
The JChemExcel formulas will not contain the installation path in the workbooks created from now on.
But you will lose the formula descriptions/context help in the Function Wizard dialog for the JChemExcel functions.