• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Editing Links

If the name of the source document changes, you'll need to edit the link to keep the data up-to-date. You can edit the external reference directly, or you can change the source by following these steps:

1.
With the dependent workbook active, choose Edit, Links to display the Edit Links dialog box.

2.
Select the link you want to change.

3.
Click Change Source. Excel displays the Change Source dialog box.

4.
Find and then choose the new source document, and then click OK to return to the Edit Links dialog box.

5.
Click Close to return to the workbook.

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint