PivotTableReference class

2.6.87 CT_PivotTableReference

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_PivotTableReferences

A complex type that specifies a relationship identifier to a PivotTable ([ISO/IEC-29500-1] section 18.10) part in this workbook.<63> The PivotTable specified by the element pivotTableDefinition ([ISO/IEC-29500-1] section 18.10.1.73) identified by this type MUST be a Non-Worksheet PivotTable and MUST satisfy the following criteria.

The ref attribute of the child element location ([ISO/IEC-29500-1] section 18.10.1.49) MUST begin with "A1".

The enableEdit attribute of the CT_PivotTableDefinition element, as specified in section 2.6.32, MUST NOT exist or MUST be "false" if exists; CT_PivotEdits and CT_PivotChanges elements MUST NOT exist in this part.

The PivotTable name specified by the name attribute of the element pivotTableDefinition ([ISO/IEC-29500-1] section 18.10.1.73), MUST be unique among all the PivotTables in the workbook.

There MUST be a child CT_PivotCache ([ISO/IEC-29500-4] section A.2) element within the pivotCaches element, specified by section 2.4.39, with the attribute cacheID having the same value as the cacheId attribute of the element pivotTableDefinition ([ISO/IEC-29500-1] section 18.10.1.73).

The PivotTable MUST NOT have CT_ConditionalFormats element as specified by section 2.6.49.

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC-29500-1] section 22.8.2.1) attribute that specifies a relationship identifier to a PivotTable part in this workbook.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_PivotTableReference">

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

</xsd:complexType>

See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Reference