I created an add-in with a user-defined formula and distributed the add-in to others. Everything works fine except when somebody tries to send a spreadsheet using that UDF to someone else with the same add-in. Excel inserts the location of the add-in into the formula (e.g. "c:\my documents\addin.xla"). Is there any way to correct this so that multiple users with the same add-in can share workbooks using that add-in?

Thanks in advance...