DisableRefresh Element (Microsoft Excel)

Specifies whether refreshing and editing is enabled for a query table, or whether a PivotTable cache can be refreshed by the user.

Contained In

PTSource, QueryTable

Remarks

If <x:DisableRefresh/> is specified, refreshes are disabled.

Examples

See the examples in the PivotTable and QueryTable element topics.