Supress Query Refresh dialog on opening workbook

[Paul Tugwell]

I have a workbook with 3 data import queries linked to a database via an
ODBC driver.
One of the queries uses parameters, the others do not.
The queries are all set not to automatically refresh on opening, but every
time I open the workbook I get the Query Refresh dialaog with the option to
enable/disable automatic query refresh.
How do I supress the display of this dialog?
I have tried putting a macro to do this in the wokrbook_open event. This
does not work.

[TonyL]

This has been bugging me for some time. I have seen a few messages on this
but no one had been able to answer this. I finally managed to track it down
in a MS article:

http://support.microsoft.com/default.aspx?id=248204

HTH
--
Tony


"Paul Tugwell" wrote:

> I have a workbook with 3 data import queries linked to a database via an
> ODBC driver.
> One of the queries uses parameters, the others do not.
> The queries are all set not to automatically refresh on opening, but every
> time I open the workbook I get the Query Refresh dialaog with the option to
> enable/disable automatic query refresh.
> How do I supress the display of this dialog?
> I have tried putting a macro to do this in the wokrbook_open event. This
> does not work.
>
>
>