Pivot Table Cache Definition Part

Content Type:

application/vnd.openxmlformats-officedocument.spreadsheetml.pivotCacheDefinition+xml

Root Namespace:

http://schemas.openxmlformats.org/spreadsheetml/2006/main

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotCacheDefinition

An instance of this part type contains a cache definition for a pivot table.

A package shall contain exactly one Pivot Table Cache Definition part per pivot table, and each such part shall be the target of an implicit relationship from a Pivot Table (§12.3.11) part as well as an explicit relationship from a Workbook (§12.3.23) part.

example:
<Relationships xmlns="…">
  <Relationship Id="rId1" 
    Type=http://…/pivotCacheDefinition
    Target="../pivotCache/pivotCacheDefinition2.xml"/>
</Relationships>

The root element for a part of this content type shall be< pivotCacheDefinition>.

example:
<pivotCacheDefinition  r:id="rId1" refreshedBy="John Jones"
  refreshedDate="2005-11-18T16:47:49" createdVersion="3"
  refreshedVersion="3" recordCount="11">
  <cacheSource type="worksheet">
    <worksheet range="C4:C15" sheet="Sheet1"/>
  </cacheSource>
  <cacheFields count="1">
    <cacheField name="1000">
      <sharedItems containsSemiMixedTypes="0" containsString="0"
        containsNumber="1" containsInteger="1" minValue="234
        maxValue="2543"/>
    </cacheField>
  </cacheFields>
</pivotCacheDefinition>

A Pivot Table Cache Definition part shall be located within the package containing the source relationship (expressed syntactically, the @TargetMode attribute of the <Relationship> element shall be Internal).

A Pivot Table Cache Definition part is permitted to have an explicit relationship to the following part defined by this Standard:

  • Pivot Table Cache Records (§12.3.13).

A Pivot Table Cache Definition part shall not have any implicit or explicit relationships to other parts defined by this Standard.