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.