file not found when opening the file
 

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.

file not found when opening the file
 

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

file not found when opening the file
 

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.