Microsoft Office Tutorials and References
In Depth Information
Changing links to different workbooks
Changing links to different workbooks
If you create a link to a value in another workbook, you might
find that the other workbook’s structure changes. You can
update the properties of a link by using the Edit Links dialog
box, which you can open using the controls on the Data tab of
the ribbon.
Change links to different workbooks
1 Click the Data tab.
2 In the Connections group, click Edit Links.
3 Click the link that you want to change.
4 Click Change Source.
5 Click the workbook with the new cell to which you want to link.
6 Click Open.
7 Select the sheet from which to update values.
8 Click OK.
9
2
1
3
4
Click Close.
7
8
9
5
TIP Under certain circumstances, such as when the new target
workbook contains a single worksheet, the option to select a
sheet might not appear.
6
Search JabSto ::




Custom Search