Whenever a user clicks that cell to edit it, it will open the link in your web browser. And if you send your Excel file to someone else, some links may no longer work. In this tutorial, we’ll explain how to break links in Excel.
How to Break External Links in Excel
To break linked data: Note: You can use Excel’s VBA code to break links in your current workbook automatically. However, such a macro will only delete the links when you click Break Link as above, so setting it up isn’t worth the effort.
How to Find and Delete Links in Named Ranges
Excel professionals often give their ranges and cells defined names to make formulas and data validation drop-down rules easier to create. You can find links to external sources as follows:
How to Find Cells With External Links
If you aren’t sure where your links are, you can use the Excel Find feature to discover any external links: Note: To find links within objects like graphs and pivot tables, you’ll have to open the properties for that object. For graphs, select the chart title. For pivot tables, select the Analyze tab, then select Change Data Source.
No More Links
Whenever you copy cells and worksheets from other Excel workbooks, you also copy any external links to other worksheets. These no longer work in your new workbook and can be a pain to eliminate when tidying up your Excel spreadsheet. However, with these Excel tips, you can easily remove links in Excel and clean up your source files.
