ConsolidationReference element (PTSourceType complexType)

Describes the file and worksheet range that the PivotTable view is based on when the PivotTable view is created from an Excel list or database.

Usage

      
<ConsolidationReference />

    

Element Information

Element type ConsolidationReferenceType
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
FileName Contains the name of the file that contains the source range of a PivotTable report.
Name Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.
Reference Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.

Attributes

None.

Definition

      
<xsd:element name="ConsolidationReference" type="ConsolidationReferenceType" 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