If you right click on the query and select options or properties, you should
have refresh options of query every "n" minutes and/or query on file open.

--
Regards,
Tom Ogilvy


"Ben" wrote:

Hi all,

I have an Excel file with three tabs, each tab has a query set up to draw
new data each morning. The data comes from a database table which gets
freshed every morning. But I am not sure how make it Excel to re-query the
external data and draw in the new data from Excel.

I set up the queries as follow in the same way for each tab:
Data-Import External Data-New Database Query...

Thanks for sharing your suggestions.

Ben

--