Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're planning an upgrade Office 2003 -> 2010 and have identified a big problem.

In Office 2003, if the workbook you're opening contains a query table that fetches data from a data source automatically (upon file open or in certain intervals), then a security dialog pops up - whether you want to allow that.

  • If you say Yes, the queries will refresh automatically when they need to.
  • If you say No, the queries will not refresh automatically, neither on file open nor on time intervals, but you will be able to refresh any of them manually at any time by right-clicking and selecting Refresh.
  • There is also a registry parameter to say, Don't display that dialog, just allow the queries.

This is exactly what we want.
On users' computers we have the registry parameter applied, so the users never see any dialogs.
On developers' computers the parameter is not applied, so every time a file is opened the developer decides whether to allow the auto-refreshing for the current session. Usually the answer is No, because for developing, it is essential to not have quieres refresh when they want to, but instead, refresh them when the developer wants.

The problem is that in Office 2010 which we are testing we can't find a way to achieve this functionality:

  • The allow/disallow messages are now grouped into one yellow button, that either allows everything or disallows everything (including, say, macros, if macro security is set to "Disable, but ask").
  • If you don't click the yellow Allow button, the queries are disabled completely, not just for automatic execution. You cannot right-click and refresh a particular query -- doing that would summon a security dialog prompting for enabling queries, and if you say Yes, all queries in the document will be enabled for auto-execution and will start executing immediately.

This sort of ruins our development environment.

Is there a way to get the trust thingies in Office 2010 to work in the same way as before? Is there a yet another registry parameter to say, Prompt for auto-refresh, but allow manual refresh even when auto-refresh is disabled?

share|improve this question
  1. Setup trusted locations in the trust center - You may need need to add both the location on spread sheet and linked data source.

  2. Tweak the File Block settings for non-dev's so it allows everything you want to open without the warning (yellow ribbon).

share|improve this answer
We know how to open a file without a warning for non-devs. We know how to open a file with a warning for devs. We don't know how to make the warning prevent the auto-refresh while not preventing the manual refresh (as it used to be in Office 2003). – GSerg Jun 22 '12 at 23:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .