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
|
|||
|
|||
Multiple Links
Hello
We have several spreadsheets that all have multiple links to other documents on different shares. These shares will be moving to a different server in a couple of weeks and we are a bit concerned about what is going to happen to all the links. Will these be automatically updated or is there anyway of updating the links as a whole to save having to go through each individual link and recreate link? Thanks |
#2
|
|||
|
|||
Rich wrote:
Will these be automatically updated or is there anyway of updating the links as a whole to save having to go through each individual link and recreate link? If the links are to files in the same directory or a subdirectory thereof there should be no problems. Otherwise there will be. You might find my LinkManager utility (available free by emailing me at Bill_Manville @ compuserve.com without the spaces) helpful. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
try LinkDissolver
www.tech-science.com "Bill Manville" wrote: Rich wrote: Will these be automatically updated or is there anyway of updating the links as a whole to save having to go through each individual link and recreate link? If the links are to files in the same directory or a subdirectory thereof there should be no problems. Otherwise there will be. You might find my LinkManager utility (available free by emailing me at Bill_Manville @ compuserve.com without the spaces) helpful. 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 |
Quick links for Office 2003 | djohnson | Setup, Installing & Configuration | 1 | April 29th, 2004 10:36 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Changing multiple reference links from one workbook to another | jlane | Worksheet Functions | 1 | March 18th, 2004 02:55 PM |
formula for computing multiple links | jv | Worksheet Functions | 5 | January 13th, 2004 05:08 PM |
Update Multiple Links | Russ | Worksheet Functions | 1 | October 9th, 2003 11:47 PM |