Reference element (SourceConsolidationType complexType)
Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.
Usage
<Reference />
Element Information
Element type
|
Anonymous |
Namespace
|
urn:schemas-microsoft-com:office:excel |
Schema name
|
XML Spreadsheet 2000 |
Elements and Attributes
Parent Elements
Element |
Description |
SourceConsolidation |
Describes the files and worksheets range that the PivotTable view is based on when the PivotTable view is created from multiple consolidation ranges. |
Child Elements
Element |
Description |
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. |
Attributes
None.
Definition
<xsd:element name="Reference" maxOccurs="unbounded" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ConsolidationReference" type="ConsolidationReferenceType">
</xsd:element>
<xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="4">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</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