file not found when opening the file

[Guest]

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]

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

 

[Roger Govier]

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