External Link Question
 

I have a worksheet with external links to another workbook. When I try to
update the links, I get the following error message: "unable to read file"
and the information does not update. If I manually open the sheet I am
linked to, the information updates. Is there a way to have the information
update without having to manually open the file every time? My workbook
options are set to update remote references and save external link values.
Any assistance is greatly appreciated.
Thanks,

Matt.