I suggest you put the workbook and addin into the same folder anywhere
you use it. Excel seems to cope with this OK.

Regards
BrianB
==============================================


"Leo Lin" wrote in message ...
Hi,

I have a add-in in xla format, and a worksheet that use the function of the
add-in ( they are in seperate directory) . I distribute both the add-in and
worksheet to another host. When I add the addin at the new host and open the
worksheet, a message pop up asking if update links, I clicked yes. Then I
saw the original formula has changed from "myfun(a2)" to something like
"c:\addin\myaddin.xla!myfun(a2)", and because myaddin.xla copied to a
different directory, the worksheet dosen't work any more and all the cells
give the result "#NAME?"

Can anyone help me how to let the cells' formula do not use the absolute
path for add-ins but use whatever add-in that exists?

Thank you.
Leo