Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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 ?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default 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 ?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 897
Default 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 ?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 JJ mac Setting up and Configuration of Excel 7 June 14th 07 06:54 PM
print box opens in right screen of dual screen setup why gerrys Excel Discussion (Misc queries) 1 June 30th 06 06:47 PM
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word urbanplanner Excel Discussion (Misc queries) 3 December 7th 05 03:57 PM
Need to convert point on screen to various screen resolutions Donna YaWanna Excel Discussion (Misc queries) 5 October 26th 05 10:10 PM


All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"