You could have the recipient use
Edit|Links|Change source

To point at their location of the addin.

To make life easier, you may want to tell everyone to use the same folder on the
same drive (and the same filename).

Include a note to all the recipients that they have to store the addin in:

C:\SandeepUtils\ConsolidationAddin.xla

Then they can use Tools|Addins to browse for this and install it.



Sandeep wrote:

When say user1 creates report and saves it to his local machine, the
functions refernceed in the cells are saved using an absolute address.

Like cell B11, will be referenced as
='C:\Program Files\microsoft
office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)

If user1 sends this saved report workbook to another user2, whose
excel installation is different from the original developer, The report
cannot be used unless the absolute address is mass replaced on all the
worksheets of the workbook as for this user the consolidation.xla files will
be at different location.

Can you please help inresolving this issue.

Thanks, Sandeep

--

Dave Peterson