Find Cell of External link

[luke1438]

I have a workbook with over 50 tabs and there is one external link showing up that was probably copied from a previous version. How can I find which sheet and which cell it is in before I break the link?

Thanks
Luke

 

[AlphaFrog]

Select from the Edit menu Find (Ctrl+F)

On the Find dialog:

• Find what: [
• Within: Workbook
• Lookin: Formulas
• Match entire cell contents: unchecked
• Click on Find Next

 

[luke1438]

AlphaFrog,

Thank you, you saved me hours worth work.

It would be a lot easier if Microsoft would just have something in that little link box that checks for external links.

thank you again
Luke