Contains information describing the data source of the PivotTable.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
CacheFile | Specifies the name of the XML file that contains the PivotTable source data. |
CacheIndex | Specifies the PivotCache associated with this PivotTable. |
DataMember | Contains either the MDX query that represents the source of the data for an OLAP-based PivotList control or the value XLDataSource. |
MissingItemsLimit | Specifies the maximum number of PivotItems not appearing in any records that are to be retained when a PivotTable view is refreshed. |
VersionRefreshableMin | Specifies the minimum version of Excel required to be able to refresh a PivotTable cache. |
VersionLastRefresh | Specifies a number indicating which version of Excel last refreshed the PivotTable view. |
RefreshName | Specifies the name of the user who last refreshed the PivotTable view. |
RefreshDate | Specifies the date on which the PivotTable view was last refreshed. |
RefreshDateCopy | Specifies the date on which the PivotTable view was last refreshed. Duplicates the RefreshDate element. |
ConsolidationReference | Describes the file and worksheet range that the PivotTable view is based on when the PivotTable view is created from an Excel list or database. |
NoSaveData | Specifies a Boolean indicating whether the supporting PivotTable data should be saved. |
QuerySource | Describes the data source that the PivotTable view is based on when the PivotTable view is created from an external source. |
SourceConsolidation | Describes the files and worksheets range that the PivotTable view is based on when the PivotTable view is created from multiple consolidation ranges. |
BackgroundQuery | Specifies a Boolean indicating whether the supporting data for the PivotTable view is read in the background, allowing the user to do other work in Excel. |
CubeSource | Specifies a Boolean indicating if the data source is an OLAP cube. |
DisableRefresh | Specifies a Boolean indicating if PivotTable refresh is disabled. |
HasNoRecords | Specifies a Boolean indicating that the last refresh returned zero records from the data source. |
OptimizeCache | Specifies that the PivotTable view use less memory to store the records from the data source. |
RefreshOnFileOpen | Specifies that data be fetched whenever the spreadsheet is opened. |
None.
<xsd:complexType name="PTSourceType" >
<xsd:all>
<xsd:element name="CacheFile" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="CacheIndex" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="DataMember" type="xsd:string" default="XLDataSource" minOccurs="0">
</xsd:element>
<xsd:element name="MissingItemsLimit" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="VersionRefreshableMin" type="xsd:int" minOccurs="0">
</xsd:element>
<xsd:element name="VersionLastRefresh" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshName" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshDate" type="xsd:dateTime" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshDateCopy" type="xsd:dateTime" minOccurs="0">
</xsd:element>
<xsd:element name="ConsolidationReference" type="ConsolidationReferenceType" minOccurs="0">
</xsd:element>
<xsd:element name="NoSaveData" minOccurs="0">
</xsd:element>
<xsd:element name="QuerySource" type="PTQuerySourceType" minOccurs="0">
</xsd:element>
<xsd:element name="SourceConsolidation" type="SourceConsolidationType" minOccurs="0">
</xsd:element>
<xsd:element name="BackgroundQuery" minOccurs="0">
</xsd:element>
<xsd:element name="CubeSource" minOccurs="0">
</xsd:element>
<xsd:element name="DisableRefresh" minOccurs="0">
</xsd:element>
<xsd:element name="HasNoRecords" minOccurs="0">
</xsd:element>
<xsd:element name="OptimizeCache" minOccurs="0">
</xsd:element>
<xsd:element name="RefreshOnFileOpen" minOccurs="0">
</xsd:element>
</xsd:all>
</xsd:complexType>