Problem Maintaining Relative Links

[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

 

[Harlan Grove]

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.

....

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]

 

[sgc]

Thanks for the reply, I suspected this. I'll give your solution a try. I
reckon this is a significant weakness in excel.

regards