Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Constructor wrote:

When I open my workbook I receive the message:

"The workbook you opened contains automatic links to information in another
workbook. Do you want to update this workbook with changes made to the other
workbook?"

I don't want the workbook to automatically update. When I go to Edit, Links
I can see the link and when I try to open it I receive a message that the
link does not exist.

How do I remove this link if I can't find it in the workbook? Or How do I
find where in the workbook the link exists so that I can delete it?

--

Dave Peterson