One of the rules for good worksheet hygiene (especially for larger models) is to keep the number of external links low – and remove all old/unnecessary links.
However, that is often much easier said than done as the “Break link” functionality very often fails to do exactly this – and these links can be hidden in a lot of places one would not usually think of (see the list of nasty hiding places below).
In a future post, I’ll look into some of these traps a bit more detailed – but for now, let me just recommend you this small gem: Link Finder, a free add-in that detects a lot of hidden links and allows you to remove them automatically!
Potential locations of hidden links
- Validation formulas for a cell
- Defined Names/Named Ranges (Really nasty: hidden names with links!)
- Formulas in Conditional Formatting
- Buttons/shapes linking to macros from old workbooks
- Formulas stored in “column formulas” in a table (even if all cells of this column have other formulas/values!)
Trackback from your site.