Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: PTSourceType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains information describing the data source of the PivotTable.
Collapse XSD Schema Diagram:
Drilldown into RefreshOnFileOpen in schema excel_xsd Drilldown into OptimizeCache in schema excel_xsd Drilldown into HasNoRecords in schema excel_xsd Drilldown into DisableRefresh in schema excel_xsd Drilldown into CubeSource in schema excel_xsd Drilldown into BackgroundQuery in schema excel_xsd Drilldown into SourceConsolidation in schema excel_xsd Drilldown into QuerySource in schema excel_xsd Drilldown into NoSaveData in schema excel_xsd Drilldown into ConsolidationReference in schema excel_xsd Drilldown into RefreshDateCopy in schema excel_xsd Drilldown into RefreshDate in schema excel_xsd Drilldown into RefreshName in schema excel_xsd Drilldown into VersionLastRefresh in schema excel_xsd Drilldown into VersionRefreshableMin in schema excel_xsd Drilldown into MissingItemsLimit in schema excel_xsd Drilldown into DataMember in schema excel_xsd Drilldown into CacheIndex in schema excel_xsd Drilldown into CacheFile in schema excel_xsdXSD Diagram of PTSourceType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="PTSourceType">
    <xsd:annotation>
        <xsd:documentation>Contains information describing the data source of the PivotTable.</xsd:documentation>
    </xsd:annotation>
    <xsd:all>
        <xsd:element name="CacheFile" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the XML file that contains the PivotTable source data.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CacheIndex" type="xsd:int" default="1" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the PivotCache associated with this PivotTable.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DataMember" type="xsd:string" default="XLDataSource" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains either the MDX query that represents the source of the data for an OLAP-based PivotList control or the value XLDataSource.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MissingItemsLimit" type="xsd:int" default="1" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the maximum number of PivotItems not appearing in any records that are to be retained when a PivotTable view is refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionRefreshableMin" type="xsd:int" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the minimum version of Excel required to be able to refresh a PivotTable cache.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="VersionLastRefresh" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a number indicating which version of Excel last refreshed the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the name of the user who last refreshed the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshDate" type="xsd:dateTime" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the date on which the PivotTable view was last refreshed.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshDateCopy" type="xsd:dateTime" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the date on which the PivotTable view was last refreshed. Duplicates the RefreshDate element.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="ConsolidationReference" type="ConsolidationReferenceType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoSaveData" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a Boolean indicating whether the supporting PivotTable data should be saved.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="QuerySource" type="PTQuerySourceType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Describes the data source that the PivotTable view is based on when the PivotTable view is created from an external source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="SourceConsolidation" type="SourceConsolidationType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Describes the files and worksheets range that the PivotTable view is based on when the PivotTable view is created from multiple consolidation ranges.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="BackgroundQuery" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>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.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="CubeSource" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a Boolean indicating if the data source is an OLAP cube.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DisableRefresh" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a Boolean indicating if PivotTable refresh is disabled.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HasNoRecords" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies a Boolean indicating that the last refresh returned zero records from the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="OptimizeCache" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that the PivotTable view use less memory to store the records from the data source.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="RefreshOnFileOpen" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies that data be fetched whenever the spreadsheet is opened.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:all>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
CacheFile x:CacheFile 0 (1)
CacheIndex x:CacheIndex 0 (1)
DataMember x:DataMember 0 (1)
MissingItemsLimit x:MissingItemsLimit 0 (1)
VersionRefreshableMin x:VersionRefreshableMin 0 (1)
VersionLastRefresh x:VersionLastRefresh 0 (1)
RefreshName x:RefreshName 0 (1)
RefreshDate x:RefreshDate 0 (1)
RefreshDateCopy x:RefreshDateCopy 0 (1)
ConsolidationReference x:ConsolidationReference 0 (1)
NoSaveData x:NoSaveData 0 (1)
QuerySource x:QuerySource 0 (1)
SourceConsolidation x:SourceConsolidation 0 (1)
BackgroundQuery x:BackgroundQuery 0 (1)
CubeSource x:CubeSource 0 (1)
DisableRefresh x:DisableRefresh 0 (1)
HasNoRecords x:HasNoRecords 0 (1)
OptimizeCache x:OptimizeCache 0 (1)
RefreshOnFileOpen x:RefreshOnFileOpen 0 (1)
Collapse Derivation Tree:
Collapse References:
x:PTSource
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0