Finding external links

[dkidroske]

I have a large workbook with more than 20 tabs.

Sometime in the past week I must have copy/pasted a formula from another workbook because I am now getting an "external link" msg whenever I save.

Is there a quick way to find on which tab the external link is located?

Dave

 

[Andrew Poulsom]

Try Edit|Find and search for "[".

 

[Fazza]

Maybe too look in defined names?

 

[dkidroske]

Thanks, Fazza!

 

[Fazza]

BTW, for working with defined names, Jan Karel Pieterse has a popular and great utility.

http://www.jkp-ads.com/officemarketplacenm-en.asp