Definition Type: Element
Name: Reference
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
MinOccurs (1)
MaxOccurs unbounded
Abstract
Documentation:
Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.
Collapse XSD Schema Diagram:
Drilldown into Item in schema excel_xsd Drilldown into ConsolidationReference in schema excel_xsdXSD Diagram of Reference in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="Reference" maxOccurs="unbounded">
    <xsd:annotation>
        <xsd:documentation>Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:sequence>
            <xsd:element name="ConsolidationReference" type="ConsolidationReferenceType">
                <xsd:annotation>
                    <xsd:documentation>Contains the properties of a range data source.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="4">
                <xsd:annotation>
                    <xsd:documentation>Contains the name of a child item in a PivotTable field, or the index number of an item described by the PTLineItem element.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
        </xsd:sequence>
    </xsd:complexType>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
ConsolidationReference x:ConsolidationReference (1) (1)
Item x:Item 0 4