|
| 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
January 11th, 2005, 04:33 PM
|
|||
|
|||
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
January 12th, 2005, 08:22 AM
|
|||
|
|||
|
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 |
Linear Mode
