Break a link to an external reference in excel

Excel for 365 Excel 2021 Excel 2019 Excel năm nhâm thìn Excel 2013 Excel 2010 Excel 2007 More...Less


When you break a liên kết khổng lồ the source workbook of an external reference, all formulas that use the value in the source workbook are converted to their current values. For example, if you break the links to the external reference =SUM(Annual!C10:C25), the SUM formula is replaced by the calculated value—whatever that may be. Also, because this action cannot be undone, you may want khổng lồ save sầu a version of the destination workbook as a backup.

Bạn đang xem: Break a link to an external reference in excel

If you use an external data range, a parameter in the query may be using data from another workbook. You may want to check for and remove sầu any of these type of link.

Break a link

On the Data tab, in the Connections group, clichồng Edit Links.


Note: The Edit Links comm& is unavailable if your file does not contain linked information.

In the Source list, click the liên kết that you want to break.

To select multiple linked objects, hold down the CTRL key, & cliông xã each linked object.

To select all links, press Ctrl+A.

Xem thêm: Cách In Hết Khổ Giấy A4 Trong Word 2010, 2007, 2003, 2013, 2016

Cliông xã Break Link.

Delete the name of a defined link

If the link used a defined name, the name is not automatically removed. You may want khổng lồ delete the name as well, by following these steps:

On the Formulas tab, in the Defined Names group, clichồng Name Manager.

In the Name Manager dialog box, cliông chồng the name that you want to change.

Clichồng the name to select it.

Cliông xã Delete.

Cliông xã OK.

Need more help?

You can always ask an expert in the Excel Tech Community or get in the Answers community.


Need more help?

Expvà your skills
Explore Training
Get new features first
Join Insiders

Was this information helpful?

Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy khổng lồ follow
No jargon
Pictures helped
Didn't match my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Any additional feedback? (Optional)
Submit feedback

Thank you for your feedback!

What's new Store
English (United States) © 2021