Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 ? |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 ? |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
print box opens in right screen of dual screen setup why | Excel Discussion (Misc queries) | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) |