Automatic Query Refresh

Specifies how Excel behaves when opening a file that contains a query or PivotTable that has been configured to refresh automatically.


Supported on: At least Windows Vista
Automatic Query Refresh Settings


  1. Default: Prompt for all workbooks
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options
    Value NameQuerySecurity
    Value TypeREG_DWORD
    Value0
  2. Do not prompt; do not allow auto refresh
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options
    Value NameQuerySecurity
    Value TypeREG_DWORD
    Value1
  3. Do not prompt; allow auto refresh
    Registry HiveHKEY_CURRENT_USER
    Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options
    Value NameQuerySecurity
    Value TypeREG_DWORD
    Value2


excel12.admx

Administrative Templates (Computers)

Administrative Templates (Users)