Enable automatic refresh link
 

I have a workbook that I'm linking to another workbook via an access query.
This works great unless someone is editing the linked workbook. Then excel
wants to open that workbook. Is there any way to stop it from opening that
workbook?

Thanks,

Debbie