External Link to workbook

[Doubleloop]

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.

 

[Bob Bridges]

Does your remote guy have access to the folder where the other workbook is
stored? If he doesn't - if "remote" means "not connected to that network" -
then this won't work for you; you'll have to import the foreign data into the
spreadsheet you're sending to him.

If he has, I have sometimes found - I don't know exactly what defines
"sometimes" - that to make external references work I have to open the other
workbook in Excel; after that the external reference works. Other times I
don't have to do this. As I said, I haven't figured out yet what defines the
difference, but it's consistent with where the other workbook is stored so it
probably has something to do with the sort of drive it's on, or something
like that.