Share via

2.6.87 CT_PivotTableReference

  • Article

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/IEC29500-1:2016] section 18.10) part in this workbook. The PivotTable specified by the element pivotTableDefinition ([ISO/IEC29500-1:2016] 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/IEC29500-1:2016] 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/IEC29500-1:2016] section 18.10.1.73), MUST be unique among all the PivotTables in the workbook.

  • There MUST be a child CT_PivotCache ([ISO/IEC29500-4:2016] 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/IEC29500-1:2016] 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/IEC29500-1:2016] section 22.8.2.1) attribute that specifies a relationship identifier to a PivotTable part in this workbook.

The following W3C XML Schema ([XMLSCHEMA1/2] 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/2] section 2.1).