Microsoft on screen messages
 

I have created a query in excel that obtains the data from an external source.
Everything works fine --- exept every time I open the worksheet a ( query
refresh )message appears asking wether I want to enable or disable automatic
refresh
I want to enable auto refresh permanently ( for this sheet anyway ) but wish
to get rid of the message.
Any sugestions ?

Microsoft on screen messages
 

If you were to order your Query by Excel Macro, then you could probably edit
the macro to accomplish what you are asking.

Vaya con Dios,
Chuck, CABGx3



"blended mist" wrote:

I have created a query in excel that obtains the data from an external source.
Everything works fine --- exept every time I open the worksheet a ( query
refresh )message appears asking wether I want to enable or disable automatic
refresh
I want to enable auto refresh permanently ( for this sheet anyway ) but wish
to get rid of the message.
Any sugestions ?

Microsoft on screen messages
 

http://support.microsoft.com/kb/248204


HTH,
JP


On Jan 4, 8:36*am, blended mist <blended
wrote:
I have created a query in excel that obtains the data from an external source.
Everything works fine --- exept every time I open the worksheet a ( query
refresh )message appears asking wether I want to enable or disable automatic
refresh
I want to enable auto refresh permanently ( for this sheet anyway ) but wish
to get rid of the message.
Any sugestions ?