A workbook cab have external links in:
-Formulas
-Chart data series
-Pivottable data soures
-Named ranges
... and more
Is there any method (built-in) or user-defined that can help me find ALL external links in a workbook?
As it is now, Excel tells me that my workbook has external links, but I have no idea in what part of my workbook this external link is. Looking for it feels like searching for a needle in a haystack.
Bookmarks