link errors-Phantom ones
 

I inherited a work book shows a Link of another worksheet in the EDIT LINK,
but I can not find any reference to a formula in any of the sheets or
"Names". I try to delete it, it comes back as still a valid LINK. Where it
could be hidden/stored that I am not able to find it? How can I chase it down?

Try this free ad-in courtesy of Bill Manville MVP, it's really excellent,
I'm sure it will help, don't forget to thank him if it does the trick for
you!
http://www.bmsltd.ie/MVP/Default.htm
Regards,
Alan.
"JayRama" wrote in message
...
I inherited a work book shows a Link of another worksheet in the EDIT LINK,
but I can not find any reference to a formula in any of the sheets or
"Names". I try to delete it, it comes back as still a valid LINK. Where
it
could be hidden/stored that I am not able to find it? How can I chase it
down?

you can "break links "in the edit links menu Have you tried searching every
sheet with "find" and some of the text from the linked worksheet name?????
--
paul
remove nospam for email addy!



"JayRama" wrote:

I inherited a work book shows a Link of another worksheet in the EDIT LINK,
but I can not find any reference to a formula in any of the sheets or
"Names". I try to delete it, it comes back as still a valid LINK. Where it
could be hidden/stored that I am not able to find it? How can I chase it down?