Linked worksheet problem - extra worksheet linked

[Raida]

When I open a workbook it has a message that says "...your
workbook has automatic links to another workbook...". When
I enter "yes" to link, it shows me a workbook that I do
not intentionally have linked to this workbook. I have
searched each linked item in the workbooks and cannot find
this other link source. I used Edit-Link- to find the
worksheets referenced (one is correct, the other is not
one I linked) however, when I used the Edit-Find feature
and place a "!" mark to look in formulas, it takes me to
all the correct links, not the abberant link. Is there any
way to find a linked item from a specifically titled
workbook?

 

[Gord Dibben]

Raida

You could also have a link in a named range. Check Insert>Name>Define

Download Bill Manville's FINDLINK.XLA from Stephen Bullen's site.

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

With this add-in you can find and delete links.

Gord Dibben Excel MVP XL2002