Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default external data automatic refresh through macro/query

Is it possible to add to a query so as to have an external data page be
refreshed upon open of the file.

Right now, in order not to get the 'automatic data refresh' pop-up, I have
reset the automatic refresh to 'yes' deep inside my windows setup following
the intructions on this link.

(http://support.microsoft.com/kb/248204/en-us)

Is there an easier way through editing / amendingthe external data query I
wonder.

Any help much appreciated!!
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
Automatic refresh of external data Texas Tonie Excel Discussion (Misc queries) 1 April 11th 07 05:56 AM
How can I 'Enable Automatic Refresh' for Query Refresh by default Anand Deshpande Setting up and Configuration of Excel 0 December 10th 06 04:47 AM
Query Refresh-Enable Automatic Refresh Dialogue Box Terri Excel Discussion (Misc queries) 0 May 6th 05 08:21 PM
Automatic refresh of external data Keith Streich Links and Linking in Excel 2 March 10th 05 01:49 PM
Prompting to allow External Query Data Refresh Tim Baker Excel Discussion (Misc queries) 3 March 8th 05 11:29 AM


All times are GMT +1. The time now is 03:13 PM.

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

About Us

"It's about Microsoft Excel"