Open or change source workbooks of external references (links)

An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook. You create external references between workbooks to bring information from a source workbook into a destination workbook.

From a destination workbook, you can easily open the source workbook of an external reference. For example, you might want to verify that it is the workbook that you want the external reference to point to, or make changes to the source workbook. You can also easily change the source workbook in an external reference. For example, the source workbook may have been moved and you need to update the external reference to reflect the change.

What do you want to do?

Open a source workbook

Change the source workbook for all external references that use it

Change the source workbook of one external reference without affecting other external references

Open a source workbook

  1. Open the destination workbook.

  2. On the Data tab, in the Connections group, click Edit Links.

    Excel Ribbon Image

  3. In the Edit Links dialog box, click the source workbook that you want to open.

  4. Click Open Source.

Top of Page

Change the source workbook for all external references that use it

  1. Open the destination workbook.

  2. On the Data tab, in the Connections group, click Edit Links.

  3. In the Edit Links dialog box, click the source workbook that you want to change.

  4. Click Change Source.

  5. In the Change Source dialog box, click the source workbook that you want to refer to. You may need to browse to find the workbook that you want.

Top of Page

Change the source workbook of one external reference without affecting other external references

  1. Find the workbook that you want to use as the new source for the external reference, and note its location.

  2. In the destination workbook, select the cell with the external reference that you want to change.

  3. In the formula bar Button image, look for a reference to another workbook, such as C:\Reports\[Budget.xlsx], and replace that reference with the location of the new source workbook.

Top of Page

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language