external data automatic refresh through macro/query
 

Is it possible to add to a query so as to have an external data page be
refreshed upon open of the file.

Right now, in order not to get the 'automatic data refresh' pop-up, I have
reset the automatic refresh to 'yes' deep inside my windows setup following
the intructions on this link.

(http://support.microsoft.com/kb/248204/en-us)

Is there an easier way through editing / amendingthe external data query I
wonder.

Any help much appreciated!!