#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 246
Default Import External Data

I've got a small query set-up in a spreadsheet using:

DataImport External DataImport Data...

When the workbook is opened a window appears titled "Query Refresh" and
asking if I'd like to either
-Enable automatic refresh, or
-Disable automatic refresh

Is it possible to get rid of this warning so that it just always
updates when the file is opened, I've played around with the properties
of the query but can't seem to suss it out

Any help greatly appreciated
J

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Import External Data

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


WhytheQ wrote:
I've got a small query set-up in a spreadsheet using:

DataImport External DataImport Data...

When the workbook is opened a window appears titled "Query Refresh" and
asking if I'd like to either
-Enable automatic refresh, or
-Disable automatic refresh

Is it possible to get rid of this warning so that it just always
updates when the file is opened, I've played around with the properties
of the query but can't seem to suss it out

Any help greatly appreciated
J

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 filter during import of external data? CW Excel Discussion (Misc queries) 0 November 29th 06 11:51 AM
How to do Edit Query from Import External Data. Excel General Questions Excel Discussion (Misc queries) 1 July 10th 06 10:35 AM
import external data ana garcia Excel Discussion (Misc queries) 2 April 29th 06 04:05 AM
Import external data problem ardi Excel Discussion (Misc queries) 1 April 3rd 06 02:03 PM
Import external data "PROBLEM" Roger MacInnis New Users to Excel 4 July 13th 05 05:08 AM


All times are GMT +1. The time now is 05:39 AM.

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"