Where is the link???

[Guest]

Hi,
I have copied and pasted worksheet from many different workbooks. When I go
to Edit Links. It references one link from workbook I had once (a long time
ago) copied from. I can't find where in my new worksheet it coming from??
Find doesn't find it, even if I tell it to look in formulas?
How can I find where this reference is in my new workbook??

 

[Guest]

Check and see if you have any named ranges.

 

[Ken Wright]

Bill Manville's free FINDLINK addin will find that sucker no matter where it
is hiding:-

http://www.oaltd.co.uk/MVP/Default.htm

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------