I have several queries in an Excel workbook that control a number of charts.
These queries are based around a MS Access back-end. (Where all the data is stored). The way I have arranged them is to put all the queries for a given category on a single spread sheet page within my workbook. And there are several pages. The queries are for test results on many different material types used in manufacturing of printed wiring boards.
Is there a way to have all the queries refresh when the workbook is opened?
The data is updated on several machines in the manufacturing plant during the course of a week. I need the charts to be current each time the workbook is opened. Another words all the queries to be refreshed. I can do this manually by placing the cursor on the date column and selecting REFRESH DATA from the tool bar ~ but was wondering if there was a better way... being that there are about 10 different queries and I would have to go to each querie and manually refresh it.

Any help would be appreciated.

Thank you in advance.
tpearo