Hi
Try downloading Bill Manville's Findlink.xla from the site as below.
This will help you to find and adjust all of the links in your sheet.
http://www.oaltd.co.uk/mvp
--
Regards
Roger Govier
"bribri" wrote in message
...
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.