Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 23,601 times.
Learn more...
If you've linked data from other worksheets in the same project or other spreadsheets in different file, but have since changed that information, this How.com.vn will teach you how to break those links in Excel using a desktop computer. Which is useful if you've added links that you no longer want to keep active.
Steps
Download Article
Open your document in Excel. You can either open your project within Excel by going to File > Open or you can right-click the Excel file in your file browser.- This method works for Excel for Microsoft 365 and Excel 2019-2007 (Mac and Windows).
Click the Data tab. You'll see this above the document editing space with Home, Formulas, and View.Advertisement
Click Edit Links. You'll find this in the "Queries & Connections" grouping.- If you don't see this button, the Excel sheet you're working on does not have any active links.
Click the link you want to break. You'll see a list of links that are active in your spreadsheet, single-clicking one will highlight it.- If you want to select more than one link from the list, hold the CTRL (Windows) or CMD (Mac) key.
- If you want to select all the links, press CTRL + A (Windows) or CMD + A (Mac).
Click Break Link. You'll need to confirm that you want to break the link to continue.[1]
Expert Q&A
Tips
References
About This Article
1. Open your document in Excel.
2. Click the Data tab.
3. Click Edit Links.
4. Click the link you want to break.
5. Click Break Link.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
