Home 
Excel 2002 Linking Change a Link's Source
Search MS Office A-Z | Search Web Pages/ Design A-Z
Change a Link's Source
- Choose Edit and Links. (This menu item is unavailable until you set up a link in a workbook.)
- Click the link you want to update and click Change Source..
- Choose the workbook you want to link to. The link will be to the same cell address as the old one, but in the new workbook. If the original link was to cell B20, the new link is to cell B20 in the new workbook you selected.
- When you click Change Source, any links using the old workbook's name will switch to the new workbook, making it a fast way to adjust multiple links to the same source workbook.