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??

Check and see if you have any named ranges.

"Ivano" wrote:

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??

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 :-)
------------------------------*------------------------------*----------------


"Ivano" wrote in message
...
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??