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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
COPYING FOLDERS CONTAINING LINKED WORKBOOKS
I HAVE A FOLDER CONTAINING MANY WORKBOOKS THAT ARE LINKED TO EACH OTHER.
WHEN I COPY THE FOLDER, THE WORKBOOKS REMAIN LINKED TO THE WORKBOOKS IN THE ORIGINAL FOLDER I NEED THE WORKBOOKS TO BE LINKED TO THE WORKBOOKS IN THE COPIED FOLDER. I HAVE TOO MANY LINKS TO HAVE TO EDIT EACH LINK IN THE WORKBOOKS IN THE COPIED FOLDER. HELP! |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Moving from dead computer to new one | Elbert | Installation & Setup | 20 | January 18th, 2005 01:10 PM |
Linked workbooks | Matt Riddler | Links and Linking | 1 | November 23rd, 2004 11:14 PM |
linked workbooks | dmk | Worksheet Functions | 1 | August 9th, 2004 07:54 PM |
Excel VBA - Copying Sheets to Closed Workbooks | Ron de Bruin | Worksheet Functions | 3 | March 25th, 2004 06:19 PM |
copying worksheets to other workbooks | Roy | Worksheet Functions | 1 | September 17th, 2003 07:18 PM |