Dear all,

I have set formulae to lookup reference data in another workbook kept in
same network drive. I tried to send source workbook to another guy operating
in remote office. He opened the wbk but the path regarding external link to
the ref. data wbk changed. How can I set the formulae in order to keep the
path name intact when the source wbk emailed to him ? Coz I have to send
updated ref data periodically for him to update.

Your help is very much appreciated.

--
Regards,
Frankie