Error "Invalid value '#NAME?' for Expiry Date!" appears when registering a chemical with "WAT Register Substance" and FormDesignerUDF is active - WKB61668

SYMPTOMS

• When using the WAT Register Substance form from the NuGenesis Smart Procedures Application Pack 1, the following error message is seen in the Form Chemicals Error section metadata:
  • Error at save: Invalid value "#NAME?" for Expiry Date!
• The substance is not entered into the reagents inventory
• Reopening the form, closing it, and re-releasing the section adds the new substance to the inventory, but the issue occurs again with other copies of the WAT Register substance form

ENVIRONMENT

• NuGenesis 8 LMS

CAUSE

Unknown. Possibly a defect in Excel, which changes the formula for the substance's expiry data such that it cannot calculate the expiry date.

FIX or WORKAROUND

1. Save the document as a template:
   1. Click the Document menu > Save as template...
   2. Click "Create new template"
   3. Save the template
   4. Click the Template menu > Export
   5. Export the template to a .vp file
2. Send the .vp file to GSS for analysis.

ADDITIONAL INFORMATION

One possible solution—not yet tested—is a registry key change:

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Wow6432Node\TypeLib\{00020813-0000-0000-C000-000000000046}
Expand the keys below this one. For Office 365 you should see one key "1.9". In systems where this issue occurs, it was found that there were two keys: 1.7 and 1.8. In one case, they had Office 2010, with a "1.7" key, with a key named "0" below it, and "Win32" below that one. That is the correct structure of the keys. However, there was also a "1.8" key, but without the "0" and "Win32" keys. The theory is that Excel sometimes uses the 1.7 key and it works, and sometimes it uses the 1.8 key and it doesn't work.

This key defines the library file (DLL) for the main Excel objects. Without that DLL loaded properly, the Waters UDF add-in cannot work.