The Edit Links dialog shows the links in formulas that are easy to find.
Unfortunately there are other places that links can hide that are WAAAYY harder to track down. Also unfortunately, those sneaky links can get added by copy/pasting ranges from other workbooks without first making sure those features are not being used in the copied ranges.
The other places that external links might be hiding are in:
- Named Ranges
- Validation Lists
- Conditional Formats
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|