Work with links 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 to the source workbook of an external reference, all formulas that use the value in the source workbook are converted lớn their current values. For example, if you break the links lớn 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 to save a version of the destination workbook as a backup.

You watching: Work with links in excel

If you use an external data range, a parameter in the query may be using data from another workbook. You may want lớn check for và remove sầu any of these type of links.

Break a link

On the Data tab, in the Connections group, cliông chồng Edit Links.


Note: The Edit Links command is unavailable if your tệp tin does not contain linked information.

In the Source các mục, cliông xã the link that you want lớn break.

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

To select all links, press Ctrl+A.

See more: Uefa Sẽ Loại Bỏ Hệ Thống Luật Công Bằng Tài Chính Trong Bóng Đá Là Gì?

Click Break Link.

Delete the name of a defined link

If the liên kết used a defined name, the name is not automatically removed. You may want to delete the name as well, by following these steps:

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

In the Name Manager dialog box, clichồng the name that you want lớn change.

Click the name khổng lồ select it.

Click Delete.

Cliông xã OK.

See more: Cách Chơi Hoa Quả Nổi Giận Trên Máy Tính, Plants Vs Zombies, Game Hoa Quả Nổi Giận 2 Mobile

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

A subscription lớn make the most of your time
Try one month free

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 lớn 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