Home / Exel / break a link to an external reference in excel Break a link to an external reference in excel 23/11/2021 Excel for nghiencongnghe.org 365 Excel 2021 Excel 2019 Excel năm nhâm thìn Excel 2013 Excel 2010 Excel 2007 More...Less Important: 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 nghiencongnghe.org in the Answers community. Need more help?Expvà your skillsExplore TrainingGet new features firstJoin nghiencongnghe.org InsidersWas this information helpful?YesNoThank 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 issueClear instructionsEasy khổng lồ followNo jargonPictures helpedOtherDidn't match my screenIncorrect instructionsToo technicalNot enough informationNot enough picturesOtherAny additional feedback? (Optional)Submit feedbackThank you for your feedback!×What's newnghiencongnghe.org StoreEducationEnterpriseDeveloperCompany English (United States) © nghiencongnghe.org 2021