Read more and check out the sample workbook at
https://spreadsheetvault.com/external-links-selected-cells/

This article and video will present a way to break external links from selected cells in Excel. As we know, Excel does not allow users to break only some of these external links.

To break external links from selected cells, we will require a macro that can to step over, or disregard standard formula cells.

1:15 Current limitation of breaking external links in Excel
2:20 How to break external links from selected cells
2:49 Go to Visual Basic for Applications and insert a Module
3:55 Writing the macro, killLinksSelection
5:38 Loop code to ensure the macro passes across each cell in the selected range
8:14 Reviewing the macro
9:00 Running the macro

Please take the opportunity to connect and share this video with your friends and family if you find it useful.