(Msg. 1) Posted: Tue Jul 08, 2008 11:21 am
Post subject: Links between workbooks Archived from groups: microsoft>public>excel>links (more info?)
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
(Msg. 2) Posted: Tue Jul 08, 2008 8:55 pm
Post subject: Re: Links between workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Tue Jul 08, 2008 8:55 pm
Post subject: Re: Links between workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
>
(Msg. 4) Posted: Tue Jul 08, 2008 10:02 pm
Post subject: Re: Links between workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I repeat my previous reply.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
(Msg. 5) Posted: Tue Sep 02, 2008 10:30 pm
Post subject: Re: Links between workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
>
>
(Msg. 6) Posted: Wed Sep 03, 2008 3:04 am
Post subject: Re: Links between workbooks [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office