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 (destination file: The file that a linked or embedded object is inserted into. The source file contains the information that is used to create the object. When you change information in a destination file, the information is not updated in the source file.) workbook, you can easily open the source (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) 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

  1. Open the destination workbook.
  2. On the Data tab, in the Connections group, click Edit Links.

Excel Ribbon Image

  1. In the Edit Links dialog box, click the source workbook that you want to open.
  2. Click Open Source.

Top of Page 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.
  1. In the Edit Links dialog box, click the source workbook that you want to change.
  2. Click Change Source.
  3. 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 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 (formula bar: A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell.) Formula bar, 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 Top of Page

 
 
Applies to:
Excel 2007