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 ?
CLR - 04 Jan 2008 18:19 GMT
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
> 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
[quoted text clipped - 3 lines]
> to get rid of the message.
> Any sugestions ?
JP - 04 Jan 2008 20:13 GMT
http://support.microsoft.com/kb/248204
HTH,
JP
On Jan 4, 8:36 am, blended mist <blended
m...@discussions.microsoft.com> 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
[quoted text clipped - 3 lines]
> to get rid of the message.
> Any sugestions ?