Dynamic Linking

U

user33

I have two excel files that are linked. I am trying to make the lin
between the two files dynamic so that people can copy the two file
together to any folder on their computer and they will still interac
correctly and update off each other.

Using the standard linking you have to put in the full address, an
when the files are moved the link does not update. It still looks fo
the files in the old location.

I am trying to automate this, so that people don't have to constantl
go back to their link menu and update the links to change the fil
location.

To summarize:
I want the linking to always look in the same folder that the file i
currently in for the other file.

Any help would be appreciated.

Thanks
 
D

Dave Peterson

If they open both workbooks in excel and save them each to the new location,
does that work?
 
Top