Maintain Element (Microsoft Excel)

Specifies whether a connection is kept open.

Contained In

QuerySource

Remarks

If <x:Maintain/> is specified, the connection is kept open to speed up access to the same data source, but if this element is not specified, the connection is closed after data is refreshed.

Example

See the example in the PivotTable element topic.