no. the file must be open. you can set the query
properties to auto-refresh on open.
to set this property, right click somewhere in the query
range. select data range properties. in the external data
range property box, select refresh data on file open.
regards
