[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

pivotCache (PivotCache)

This element represents a cache of data for pivot tables and formulas in the workbook.

Parent Elements

pivotCaches3.2.18)

 

Attributes

Description

cacheId (PivotCache Id)

Specifies the unique identifier for the pivot cache for this workbook in the pivot cache part.

 

This attribute is required.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

id (Relationship Id)

 

Namespace: .../officeDocument/2006/relationships

Specifies the identifier to a pivot cache definition part where cached data is stored.

 

This attribute is required.

 

The possible values for this attribute are defined by the ST_RelationshipId simple type (§7.8.2.1).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_PivotCache">

   <attribute name="cacheId" type="xsd:unsignedInt" use="required"/>

   <attribute ref="r:id" use="required"/>

</complexType>