A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Links between workbooks



 
 
Thread Tools Display Modes
  #1  
Old July 8th, 2008, 07:21 PM posted to microsoft.public.excel.links
JimD
external usenet poster
 
Posts: 27
Default Links between workbooks

Is there a way to maintain a link(s) between workbooks contained within
sub-folders of a master folder when you copy the master folder? Right now all
the links refer back to the workbook in the copied folder.
--
JimD
  #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


  #3  
Old July 8th, 2008, 09:55 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Links between workbooks

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

  #4  
Old July 8th, 2008, 11:02 PM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Links between workbooks

I repeat my previous reply.

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

  #5  
Old September 3rd, 2008, 06:30 AM posted to microsoft.public.excel.links
CathH
external usenet poster
 
Posts: 1
Default Links between workbooks

Hi Bill,

I am planning a data migration and would like to scan prior now to identify
which workbooks have external references that will be affected by a path
change. Would you please send me a copy of your LinkManager Utility to
enable me to do this.

CathH

"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


  #6  
Old September 3rd, 2008, 08:17 AM posted to microsoft.public.excel.links
Bill Manville
external usenet poster
 
Posts: 258
Default Links between workbooks

CathH wrote:
Would you please send me a copy of your LinkManager Utility to
enable me to do this.


I would be very happy to do so.

Unfortunately I don't know your email address.
So why don't you email me (Bill underscore Manville at Compuserve dot
com) with the request so that I can attach it to my reply.

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.