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