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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
