View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AFSSkier AFSSkier is offline
external usenet poster
 
Posts: 94
Default query to external data

Tony,

Click the Microsoft Office Button (upper left), and then click Excel Options.
Click Trust Center, and then click Trust Center Settings.
Click a dot on "Never show info about block content".

--
Kevin


"Tony7659" wrote:

Whenever I open a file getting data from an external source I get a window as
follows:
Title:
Query Refresh
Message:
Path\....
This workbook contains queries to external data that refresh automatically
Enable automatic refresh / Disable automatic refresh
How can I avoid this message and default it to Enable automatic refresh?
Thank you. Tony.