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
|
|||
|
|||
Updating links to new workbook with same format
I have a spreadsheet that is linked to 3 other spreadsheets. We keep a
history of our data for each month, so the file will get renamed every month. However the file that is linked to the other 3 will still be pointing to last month's spreadsheets. Is there an easy way to change the links to a new spreadsheet? |
#2
|
|||
|
|||
Andy wrote:
Is there an easy way to change the links to a new spreadsheet? Edit / Links / Change Link 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 |
Updating links to another workbook after sorting | Andy at BLE | Worksheet Functions | 0 | June 16th, 2004 09:21 PM |
Copying Worksheet without links to parent workbook | Vasant Nanavati | Worksheet Functions | 0 | June 16th, 2004 04:53 PM |
email format | Lloyd | General Discussion | 1 | June 16th, 2004 03:42 AM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |
Excel Links to files on network not updating | Bobbie Jo | Worksheet Functions | 0 | January 13th, 2004 09:02 PM |