Problem Maintaining Relative Links

  • Thread starter Thread starter sgc
  • Start date Start date
S

sgc

Could someone perhaps shed some light on this issue?

I have a project management system which uses a source spreadsheet to
disseminate basic project information, names, dates etc to numerous
other spreadsheets loacated within sub-folders inside the same basic
folder. As it stands this works fine. However when I copy the entire
structure to set up for another project, instead of using relative
linking, the copied structure always uses absolute linking and reads
back to the original (master) setup.

I can change individual sheets using the update links function, but
given that the information on the souce sheet is copied across to about
20 other sheets this is time consuming.

What I need is a way to copy the basic structure, but maintain relative
linking.

Any ideas would be appreciated

regards
 
sgc said:
I can change individual sheets using the update links function, but
given that the information on the souce sheet is copied across to about
20 other sheets this is time consuming.

What I need is a way to copy the basic structure, but maintain relative
linking.
Click to expand...
....

For whatever reason (and, believe me, I can speculate on some that would be
rather unflattering to Microsoft), Excel external link references to other
workbooks can *only* use fully qualified pathnames. There's no way to use
relative pathnames without creating dynamic external links.

To do that, see

http://groups.google.com/[email protected]
 
Thanks for the reply, I suspected this. I'll give your solution a try. I
reckon this is a significant weakness in excel.

regards
 
Back
Top