Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
query to external data
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
query to external data
Kevin,
Is there a way to do it through code for a single sheet? I have other files where I would like to have this option open to my choice. Thank you. Tony. "AFSSkier" wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
query to external data
Tony,
Unfortuniately I'm a newbie when it comes to vba code. However as I was searching for something else for myself, I found some code that may help you. From the VB coding post & to quote Don Guillett "try something like" for each q in thisworkbook.querytables q.refresh next q -- Hope this helps you. If not, don't stop searching. I've learned more from this site & it's links. More than anywhere else. The MVPs are very helpful here! I'm an Excel & Access power user & try to help out where I can. Kevin "Tony7659" wrote: Kevin, Is there a way to do it through code for a single sheet? I have other files where I would like to have this option open to my choice. Thank you. Tony. "AFSSkier" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Query | Excel Discussion (Misc queries) | |||
Get External Data-New Web Query | Excel Discussion (Misc queries) | |||
External Data Query | Excel Programming | |||
Query of External Data | Excel Discussion (Misc queries) | |||
Get External Data Query | Excel Programming |