I think by Sheet A you are meaning a workbook, not a worksheet within a
workbook as Dave took you to mean.

I have an alternative free utility which you can use to look in all xls
files in a directory structure, looking for links to a particular
workbook. If you would like to try it, email me at Bill_Manville at
compuserve dot com

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup