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

bribri wrote:

when opening the file, the file will open and it will have a message "file
not found" for certin linked file. i have to keep pressing "cancel" for
about 20 times since it is looking for 20 different file. i think the
workbook is linked. is there a way to figure what is being linked and how i
can take that link out? thx.

--

Dave Peterson