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

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

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

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

Any help would be appreciated.

Thanks.


--
user33
------------------------------------------------------------------------
user33's Profile: http://www.excelforum.com/member.php...o&userid=25873
View this thread: http://www.excelforum.com/showthread...hreadid=392553

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

user33 wrote:

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

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

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

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

Any help would be appreciated.

Thanks.

--
user33
------------------------------------------------------------------------
user33's Profile: http://www.excelforum.com/member.php...o&userid=25873
View this thread: http://www.excelforum.com/showthread...hreadid=392553

--

Dave Peterson