Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Disable prompt for external query
My worksheet includes an external query set to run when the file is opened.
Whenever the file is opened, the user gets prompted to enable automatic refresh. Is this possible to automatically bypass? I'd like the query update to happen seamlessly without any prompting. |
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Disable prompt for external query
This link will provide details of how to do what you want:
http://office.microsoft.com/en-gb/as...362611033.aspx "Hall" wrote: My worksheet includes an external query set to run when the file is opened. Whenever the file is opened, the user gets prompted to enable automatic refresh. Is this possible to automatically bypass? I'd like the query update to happen seamlessly without any prompting. |
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Disable prompt for external query
Richard
I have no idea what this means. I'm not sure if you sent me to the wrong page or to a specific piece and context or explanation is provided elsewhere. Please give me a bit more guidance on this... Thx! "Richard" wrote in message ... This link will provide details of how to do what you want: http://office.microsoft.com/en-gb/as...362611033.aspx "Hall" wrote: My worksheet includes an external query set to run when the file is opened. Whenever the file is opened, the user gets prompted to enable automatic refresh. Is this possible to automatically bypass? I'd like the query update to happen seamlessly without any prompting. |
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Disable prompt for external query
Hall,
These are office policies, and control how every user sees and uses the office suite. The section you need is further down under 'Policies in the Excel policy template'. If you talk to your system administrator about this, then they should be able to configure the system to automatically update the query when you open it. I hope you can work it out! Richard "Hall" wrote: Richard I have no idea what this means. I'm not sure if you sent me to the wrong page or to a specific piece and context or explanation is provided elsewhere. Please give me a bit more guidance on this... Thx! "Richard" wrote in message ... This link will provide details of how to do what you want: http://office.microsoft.com/en-gb/as...362611033.aspx "Hall" wrote: My worksheet includes an external query set to run when the file is opened. Whenever the file is opened, the user gets prompted to enable automatic refresh. Is this possible to automatically bypass? I'd like the query update to happen seamlessly without any prompting. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Allow ActiveX prompt | Excel Discussion (Misc queries) | |||
disable query refresh prompt? | Excel Discussion (Misc queries) | |||
Disable Message Prompt in VBA | Excel Programming | |||
Disable Excel Prompt | Excel Programming | |||
Prompt to enable/disable macros | Excel Programming |