linking across workbooks

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking multiple cells between workbooks 2
linking workbooks when source data moves 1
External Links in Excel 2007 with variable source file 5
Link to another workbook path issue 1
linking worksheets to a closed workbook 2
Auto Populating Fields from many worksheets to one main worksheet 1
Excel 2007 - Linking workbooks 1
Linked cells limited to ~253 characters unless source file open 3

Top