Message from discussion COPYING FOLDERS CONTAINING LINKED WORKBOOKS

Date: Sat, 24 Sep 2005 08:39:51 +0100
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Newsreader: Virtual Access by Atlantic Coast PLC, http://www.atlantic-coast.com/va
Organization: Bill Manville Associates
Message-ID: <VA.0000138b.19d010de@msn.com>
Subject: Re: COPYING FOLDERS CONTAINING LINKED WORKBOOKS
From: Bill Manville <Bill-Manvi...@msn.com>
Reply-To: Bill-Manvi...@msn.com
References: <g_VYe.303926$on1.15857@clgrps13>
Newsgroups: microsoft.public.excel.links
NNTP-Posting-Host: ip154.net176.adsl.community.co.uk 195.72.176.154
Path: g2news1.google.com!news2.google.com!newsread.com!newsprint.newsread.com!news-feed01.roc.ny.frontiernet.net!nntp.frontiernet.net!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
Lines: 1         

You may not know that writing in CAPITALS is understood to be shouting.
It certainly makes it harder to read your message.

If the workbooks are linked to others in the same folder and you are 
talking about formula links, those links will usually adjust when you 
move all the files (e.g. using Windows Explorer).

I assume therefore that you are talking about hyperlinks.
In that case (and in general when you post to a newsgroup) it would be 
helpful to know which version of Excel you are using.

I can send you a LinkManager utility which will change the hyperlinks 
in all workbooks in a directory structure from referencing a particular 
directory to referencing a different one.

If you think it would help you, email me at 
Bill _ Manville @ compuserve.com (without the spaces).

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