The guide to finding and removing external links from your Excel file

So you're on a mission to remove external links from your Excel workbook, huh?

Seems like it should be easy, but as you are probably finding out, it sometimes isn't as easy as clicking the "break links" button (unfortunately).

This post walks you through all the hiding places that external links may be lurking, including:

• Cells.
• Charts.
• Shapes.
• Names ranges.
• Pivot Tables.
• Data Validation.