Disable prompt for external query

[Hall]

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.

 

[Guest]

This link will provide details of how to do what you want:

http://office.microsoft.com/en-gb/assistance/HA011362611033.aspx

 

[Hall]

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!

 

[Guest]

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