RefreshOnFileOpen Element (Microsoft Excel)

Specifies whether the data in a PivotTable cache or query table is refreshed when a workbook is opened.

Contained In

PTSource, QueryTable

Remarks

If <x:RefreshOnFileOpen/> is specified, the data is refreshed when the workbook is opened.

Example

See the example in the QueryTable element topic.