View Single Post
  #2  
Old July 8th, 2008, 09:27 PM posted to microsoft.public.excel.links
JimD
external usenet poster
 
Posts: 27
Default Links between workbooks

I have this both on our server and locally on my C drive (which has never
been to or linked to the copy on the server) and they both hold their links
to the copied folder instead of being held relative to each other within the
folder structure.
--
JimD


"Bill Manville" wrote:

In general, links TO files in the same folder or a sub-folder thereof
are held as relative and so survive moves of the whole structure.

Links to files in the parent folder MAY be held as relative, but may
not be - especially if the folder is accessed via a UNC filename, e.g.
\\server\dir.

If the links are not held as relative then you are out of luck.
Use Edit Links Change Source.
Or, if there are lots of files with links I could offer a free utility
to change the links (LinkManager; email me at Bill underscore Manville
at Compuserve dot com).


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup