You already know that Excel allows you to establish links between your workbook and other objects, such as graphics, Word documents, and other items. (We’re talking regular links here, not hyperlinks.) There may come a time when you wish to change the links. For instance, you may have a picture linked in your workbook, and you want to change the location of the picture (to a different directory or drive). Excel allows you to change your link so it can point to the proper file as the source of the object in the workbook.
To change links in this manner, follow these steps:
- Display the Data tab of the ribbon.
- In the Connections group, click the Edit Links tool. Excel displays the Edit Links dialog box. (See Figure 1.)
- Select the link you want to change.
- Click on Change Source. Excel displays the Change Source dialog box.
- Use the controls in the dialog box to locate and select the file that will serve as the new source of the link.
- Click Open. Excel updates the link to reflect the new source you specified.
- Make any additional link changes necessary by repeating steps 2 through 5.
- Click on OK.
Figure 1. The Edit Links dialog box.