Home > Sample chapters > Microsoft Office > Excel

Using Formulas and Functions in Microsoft Excel 2013

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. Click Close.

    httpatomoreillycomsourcemspimages1602933.jpg