Pivot Table Cache Records Part

Content Type:

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

Root Namespace:

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

Source Relationship:

http://schemas.openxmlformats.org/officeDocument/2006/relationships/spreadsheetml/pivotCacheRecords

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

A package shall contain exactly one Pivot Table Cache Records part per pivot table, and each such part shall be the target of an explicit relationship in the Pivot Table Cache Definition (§12.3.12) part for the corresponding pivot table.

example:

<Relationships xmlns="…">
  <Relationship Id="rId1" 
    Type="http://…/pivotCacheRecords" Target="pivotCacheRecords2.xml"/>
</Relationships>

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

example:

<pivotCacheRecords … count="11">
  <r>
    <n v="1234"/>
  </r>
    …
  <r>
    <n v="876"/>
  </r>
</pivotCacheRecords>

A Pivot Table Cache Records 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 Records part shall not have implicit or explicit relationships to any other part defined by this Standard.