linking across workbooks

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I have run into the following issue. I am trying to link
cells from two different workbooks and have the relative
location of the link remain intact when I move/rename the
folder in which the link was created.
My objective is to create a source worksheet in a main
folder. The destination worksheets are to update from the
source. Each destination worksheet are located in
subfolders.
My problems are encountered when i copy the main folder
and paste/rename it to a new location.The change in
location is not recognized. Can anyone help?
Thanks.
 
As far as I know there is not a solution for what you are trying to do. Moving changes the location and reference, which you have to undate in the destination file. Destination is not able to know when you change a location by simply moving it or renaming it. You might, if you simply move it and not rename it, use VBA to do a find in the new location and tell your destination the new location, by using variables.
 
Back
Top