Import External Data

W

WhytheQ

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

Data>Import External Data>Import 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stopping "Query Refresh" messages 2
External Data Refresh Issues 0
query to external data 3
Import External Data 3
Prompting to allow External Query Data Refresh 3
Automatic Query Refresh 4
Refresh external data message 1
Excel Import External Data by Date Automatically 0

Top