PTSource Element (Microsoft Excel)

Contains the properties of the data source for a PivotTable report.

Contained In

PivotTable

Subelements

BackgroundQuery, CacheFile, CacheIndex, ConsolidationReference, CubeSource, DisableRefresh, HasNoRecords, NoSaveData, OptimizeCache, QuerySource, RefreshDate, RefreshName, RefreshOnFileOpen, SourceConsolidation

Remarks

All subelements are optional.

Example

See the example in the PivotTable element topic.