SourceConsolidation element

Describes the files and worksheets range that the PivotTable view is based on when the PivotTable view is created from multiple consolidation ranges.

Usage

      
<SourceConsolidation />

Element Information

Element type SourceConsolidationType
Namespace urn:schemas-microsoft-com:office:excel
Schema name XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element Description
PTSource Contains information describing the data source of the PivotTable view.

Child Elements

Element Description
Reference Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.
ConsolidationReference Contains the properties of a range data source.
Item Contains the name of a child item in a PivotTable field, or the index number of an item described by the PTLineItem element.
NoAutoPage Specifies whether page fields are created automatically for a consolidation.

Attributes

None.

Definition

      
<xsd:element name="SourceConsolidation" type="SourceConsolidationType" minOccurs="0" >
</xsd:element>
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp