Break a link to an external reference

Important   When you break a link to the source workbook of an external reference, all formulas that that use the value in the source workbook are converted to their current values. For example, the external reference =SUM([Budget.xls]Annual!C10:C25) would be converted to =45. Because this action cannot be undone, you may want to save a version of the destination workbook.

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

    Excel Ribbon Image

    Note   The Edit Links command is unavailable if your file does not contain linked information.

  2. In the Source list, click the link that you want to break.

    To select multiple linked objects, hold down CTRL, and then click each linked object.

    To select all links, press CTRL+A.

  3. Click Break Link.

  4. If the link used a defined name, the name is not automatically removed. You may want to delete the name as well.

    How to delete a name

    1. On the Formulas tab, in the Defined Names group, click Name Manager.

    2. In the Name Manager dialog box, click the name that you want to change.

    3. Click the name to select it.

    4. Click Delete. You can also press DELETE.

    5. Click OK to confirm the deletion.

Tip   If you use an external data range, a parameter of a query may also use data from another workbook. You may want to check for and remove any of these type of links.

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!

Change language