Hi,

I am looking to know how custom function names are resolved in Excel.I have
an XLA with a number of functions in it and have used it to build a large
spreadsheet.
Once the functions were settled I built an add-in DLL in delphi to replace
the XLA
for easier deployment. The new DLL works fine when building new workbooks
but existing ones which were designed with the XLA dont work even though
the function names in the new dll are identical. I guessed that excel was
storing the
path to the xla in the sheet somewhere but even if i edit the cells or call
the
DLL's functions from new cells they fail with #NAME as if they are still
trying to
find the function name in the old XLA...

This has been very frustrating so any help would save a few grey hairs...

Thanks

Aidan