Permission to copy, display and distribute the contents of this document (the “Specification”), in any medium for any purpose without fee or royalty is hereby granted, provided that you include the following notice on ALL copies of the Specification, or portions thereof, that you make: Copyright (c) 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?frame=true. No right to create modifications or derivatives of this Specification is granted herein. There is a separate patent license available to parties interested in implementing software programs that can read and write files that conform to the Specification. This patent license is available at this location: http://www.microsoft.com/mscorp/ip/format/xmlpatentlicense.asp. THE SPECIFICATION IS PROVIDED "AS IS" AND MICROSOFT MAKES NO REPRESENTATIONS OR WARRANTIES, EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, NON-INFRINGEMENT, OR TITLE; THAT THE CONTENTS OF THE SPECIFICATION ARE SUITABLE FOR ANY PURPOSE; NOR THAT THE IMPLEMENTATION OF SUCH CONTENTS WILL NOT INFRINGE ANY THIRD PARTY PATENTS, COPYRIGHTS, TRADEMARKS OR OTHER RIGHTS. MICROSOFT WILL NOT BE LIABLE FOR ANY DIRECT, INDIRECT, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF OR RELATING TO ANY USE OR DISTRIBUTION OF THE SPECIFICATION. The name and trademarks of Microsoft may NOT be used in any manner, including advertising or publicity pertaining to the Specification or its contents without specific, written prior permission. Title to copyright in the Specification will at all times remain with Microsoft. No other rights are granted by implication, estoppel or otherwise. Specifies whether a data table is displayed on the plot area next to the category axis. Contains the range or list of ranges that applies to a conditional text format, a data validation range, or a data source. Contains the row index of a cell used to calculate the values in a data table. Contains the column index of a cell used to calculate the values in a data table. Contains the properties of a workbook. Contains information about all published items in a workbook. Contains information about references and links to other workbooks and data sources. Specifies the number of sheets selected in a workbook. Specifies whether a workbook window is hidden. Specifies whether the horizontal scroll bar in a workbook window is hidden. Specifies whether the vertical scroll bar in a workbook window is hidden. Specifies whether the worksheet tabs in a workbook window are hidden. Contains a value specifying the height in points of a workbook window. Contains a value in points that specifies the width of a workbook window. Contains a value in points that specifies the horizontal position of a workbook window relative to the left border of the application window. Contains a value in points that specifies the vertical position of a workbook window relative to the top border of the application window. Contains the index number of the active worksheet in a workbook. Contains the name of the active chart in a workbook. Specifies that all worksheets before to the worksheet identified in this element are hidden and that no navigation tabs are shown for hidden sheets. Prevents the PivotTable Field List dialog box from appearing when the user moves the input focus to the PivotTable view. Specifies whether the structure of a workbook is protected. Specifies whether the worksheet windows are protected. Specifies whether ink comments are displayed. Causes smart tags in the document to be saved to the XML spreadsheet. Enables Excel 2002 to warn users that they may lose data on save back to XMLSS, when the XMLSS loaded was created with Excel 2003. This element will only be written into the XMLSS if were writing out the MapInfo collection (new feature in Excel 2003). Specifies the ratio of the worksheet tab area width to the width of the horizontal scroll bar. Specifies whether a workbook window is minimized. Specifies whether drawing objects are displayed, placeholders are displayed in their place, or all drawing objects are hidden in a workbook. Specifies whether a backup file is created when you save a workbook. Specifies the type of calculation for a PivotTable field or the mode of calculation for a workbook. Specifies whether a workbook is calculated before it is saved. Specifies the date system used in a workbook. Specifies that references are in R1C1 reference style. Specifies whether to track the number of iterations through circular references in formulas. Specifies the maximum number of iterations when resolving circular references in Excel. Specifies the maximum amount of change for a value between each iteration when Excel resolves circular references in formulas. Specifies whether calculations are performed using the precision of numbers as they are displayed. Specifies whether the values in linked cells are saved. Suppresses autorecovery of documents if Excel fails. Specifies whether range names are allowed in formulas. Specifies whether a workbook has already been calculated. Specifies the name of the spreadsheet Contains the data validation criteria, an input message, and elements related to error messages for a specified range. Contains information about autofilters. Specifies the range to which the autofilter applies. Contains the autofilter criteria for a column in an autofilter range. Contains information about the test applied in an autofilter. Contains an autofilter condition that can be combined with other conditions using the OR operator. Specifies the criteria for the autofilter. Contains an autofilter condition that can be combined with other conditions using the AND operator. Specifies the criteria for the autofilter. Specifies the column in the autofilter range to which the current autofilter applies. Specifies the type of autofilter to apply to the column. Contains a value for the autofilter condition specified in the Type attribute. Contains information about the test applied in an autofilter. Defines the test to apply in conjunction with the Value attribute. Defines the test to apply in conjunction with the Operator attribute. Contains the sorting specifications and sort options used in the most recent sort. Contains information about conditional formatting. Contains information about a section of the spreadsheet that holds the results of a query. Contains information about a PivotTable view. Contains a hyperlink to the data source of a worksheet. Specifies the path and file name of the data source. Contains information about options related to the worksheet. Specifies the list of cells to be displayed in Watch window. Specifies a reference to a cell to be displayed in the Watch window. Specifies a reference to a cell to be displayed in the Watch window. Contains information about page breaks in a spreadsheet. Contains information about page breaks in a spreadsheet. Specifies the list of columns where page breaks occur. Contains a single column where a page break occurs. Specifies the index to a column where a page break occurs. Specifies the list of rows where page breaks occur. Specifies a single row where a page break occurs Contains information about the row where a page break occurs. Contains a description of formula operands located in another workbook. Specifies the row being referenced. Specifies the column in the referenced row that the referenced area begins with. Specifies the column in the referenced row that the referenced area ends with. Contains the data in the referenced cell if the data is numeric. Contains the data in the referenced cell if the data is text. Contains a Boolean operand. Contains the data in the referenced cell if the data is an Error data type. Contains an enumeration of Excel error values. Specifies a PivotList specific complex type. Specifies the type of horizontal alignment. Specifies that the content is rotated. Specifies the type of vertical alignment. Specifies the direction of text. Contains an enumeration of the PivotTable view autoformat names. Contains an enumeration indicating the type of calculation being done for the PivotField which is in the data area of the PivotTable report. Specifies the type of calculation for a PivotTable field or the mode of calculation for a workbook. Specifies the index of a row page break in a worksheet, or for a PivotList component, represents a column of cells. Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. Specifies the horizontal position of an object within the chart area or Chart component, or for a PivotList component, the column index of the first visible detail column, or the index of the member visible at the left of a view. Contains the properties of a cell in the PivotList component. Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. Specifies the vertical position of an object within a chart area or Chart component, or for a PivotList component, the row index visible at the top of a cell or view. Specifies whether a cell's expanded state is the same as its default state. Contains information about a column. Contains a unique identifier assigned to a column or, when the page is saved as a Web page, to a cell range. Specifies whether there are enough columns to import all fields and columns returned by a query. Specifies the direction of the sort. Specifies whether formulas to the right of a query table that use values in this column are copied when the data is refreshed and new rows of data are added to a query table. 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. Specifies the location and name of a text file. Specifies whether row numbers are included in a database query. Specifies the sort order of a column. Specifies whether the column was inserted by the user. Contains the conditions and the formatting elements that are applied to the specified range when the conditions are true. Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source. Contains a condition and the formatting that is applied to a cell when the condition is true. Contains the qualifier of a condition in conditional text formatting and data validation. Contains a text string specifying the value or formula used in conditional text formatting. Contains a text string specifying the value or formula used in the second part of conditional text formatting. Specifies the text formatting that is applied to a cell when the condition is true. A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true. A text string containing attributes that describe the font weight, style, and effects that are applied when a qualifying condition is true. Contains the properties of a range data source. Contains the name of the file that contains the source range of a PivotTable report. 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. Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element. Contains the data validation criteria, input message, and error message elements of the specified range. Contains the range or a list of ranges that apply to a conditional text format, data validation range, or data source. Specifies the type of axis scaling, chart, data source, 3-D shape, or trendline, the data validation constraints on data entered into a range, or the position of legend entries. Specifies whether a list of values is used for data validation. Contains the qualifier of a condition in conditional text formatting and data validation. Specifies whether blank cells in a range are used when validating input data. Specifies the minimum value to be used for tests that use the BETWEEN operator. Specifies the maximum value to be used for tests that use the BETWEEN operator. Specifies the value to be tested. Suppresses the list of acceptable values. Specifies the status of the Input Method Editor (IME). Specifies whether an input dialog box is displayed during data validation. Contains the title of an input dialog box displayed during data validation. Contains the input message displayed during data validation. Specifies whether error messages are displayed during data validation. Contains the style of a data validation error message. Contains the data validation error message that is displayed when invalid data is entered. Contains the title of an error dialog box displayed during data validation. Contains information about a DDE or OLE link, or a referenced name that is defined in another workbook. 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. Contains the formula corresponding to a defined name, a range in another workbook, a query parameter, or a PivotTable field, formula, or item. Specifies whether the ExternName element describes an OLE link. Specifies whether the ExternName element contains a description of a DDE or OLE link, and specifies the type of link. Specifies whether data is in clipboard format. Contains an index to the clipboard data format. Contains the cell data type format settings for the columns of imported text. Specifies the cell data type formatting for a column. Contains the starting column number of a field used when importing text. Specifies the HTML tables on a Web page that are imported into a query table. Contains the index number of either an HTML table in a Web page or of a pane in a worksheet window, the number formatting style of a chart object, or a numeric operand. Contains a string operand or the name of an HTML table in a Web page. Indicates that no information is specified. Contains the properties of a leaf column member that has been expanded or collapsed since the view's state changed. Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. Contains the index of the last expand or collapse operation performed on a member. Specifies whether the field members are expanded by default, or whether a leaf member was expanded. Contains the properties of a leaf row member that has been expanded or collapsed since the view's state changed. Contains the type, path, and file name of an external or linked workbook or data source, or for a PivotList component, the name of the column, leaf, or row member of an axis or cell. Contains the index of the last expand or collapse operation performed on a member. Specifies whether the field members are expanded by default, or whether a leaf member was expanded. Contains the data referenced by a DDE link. Specifies the index of the last row of data being represented. Specifies the index of the last column of a row of data being represented. Contains the index number of either an HTML table in a Web page or of a pane in a worksheet window, the number formatting style of a chart object, or a numeric operand. Contains a string operand or the name of an HTML table in a Web page. Contains a Boolean operand. Contains an error string. Contains the Pane elements corresponding to the panes of a worksheet window. Contains the properties of a pane in a worksheet window, or specifies a pane containing the structured selection of a PivotTable report. Contains the properties of a pane in a worksheet window, or specifies a pane containing the structured selection of a PivotTable report. Contains the index number of either an HTML table in a Web page or of a pane in a worksheet window, the number formatting style of a chart object, or a numeric operand. Contains the index number of a pane's active row in a worksheet window. Contains the index number of a pane's active column in a worksheet window. Contains the selected range of a pane in a worksheet window. Contains the properties of structured selections in a PivotTable report. Contains information about a query parameter. Specifies the data type of a query parameter. Contains the formula corresponding to a defined name, a range in another workbook, a query parameter, or a PivotTable field, formula, or item. 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. Specifies a parameter type. Specifies the value of a query parameter. Contains the message displayed when the user is prompted for a query parameter. Specifies whether a query parameter has a user-defined name. Specifies the SQL data type of a query parameter or PivotTable field. Specifies whether the data from an external data source is refreshed when a cell used to calculate a parameter formula is changed. Specifies additional information about a PivotTable view axis or location. Specifies a Boolean value indicating whether empty items should be displayed in the PivotTable view. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis. Contains an enumerated value indicating where a field is located in a PivotTable area. Contains information about the data held in a spreadsheet to support a PivotTable view. Specifies the index of PivotCache. Contains a description of the state of PivotTable data, including whether members are expanded and the position of a view. Specifies the vertical position of an object within a chart area or Chart component, or for a PivotList component, the row index visible at the top of a cell or view. Specifies the horizontal position of an object within the chart area or Chart component, or for a PivotList component, the column index of the first visible detail column, or the index of the member visible at the left of a view. Specifies whether a row member has a different expanded state than its default state. Specifies whether a column member has a different expanded state than its default state. Contains the properties of a leaf row member that has been expanded or collapsed since the view's state changed. Contains the properties of a leaf column member that has been expanded or collapsed since the view's state changed. Specifies the index of a row page break in a worksheet, or for a PivotList component, represents a column of cells. Contains information about child field items. Contains the name of a child item in a PivotTable field, or the index number of an item described by the PTLineItem element. Specifies the order in which a range is displayed when a filter is applied to a PivotTable field. Specifies whether a filter is automatically applied to a PivotTable field. Specifies the sort order of a PivotTable field. Contains the function used to summarize a data field or total. Specifies how groups are ordered in a PivotTable field. Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis. For an axis scale, specifies whether the direction of the axis is from minimum to maximum or maximum to minimum. For an error bar, specifies whether the error bar is horizontal or vertical. Specifies the type of subtotal to display for a field. Specifies the text formatting that is applied to a subtotal. A text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal. Specifies the horizontal alignment of a total. Specifies the horizontal alignment of the caption for a total. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. 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. Contains the name of a field or item as it appears in a PivotTable cache. Specifies whether the PivotTable field is the bound field of an automatic date field set. Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources. Contains the caption of a field set when the field set is the current filter. Specifies whether a field is on the detail grid. Specifies the position of a field in the detail grid. Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden. Specifies the position of a PivotField when multiple fields are used. Contains a Boolean value indicating whether all PivotItems should be shown even if they have no data. Specifies the display formatting to use when displaying the PivotItem or aggregate value. Specifies the name of the PivotItem selected for a PivotField when the PivotField is in the page area. Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name. Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed. Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types. Contains the subtotal to display when a PivotTable field is not on the column or row axis. Specifies the text formatting that is applied to a field when it is on the detail grid. Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field. Specifies the text formatting that is applied to a subtotal. Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal. Specifies the width of a field (in pixels) when it appears on the detail axis. Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis. Specifies whether the field members are expanded by default, or whether a leaf member was expanded. Specifies the width of a total and whether the width is automatically set. Contains information on an item (PivotItem) in the PivotField. Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources. Contains information about a PivotField. Indicates that the PivotField element contains information for the data field of the report. Specifies the name of the PivotField. Also specifies the field in the data source that the PivotField represents. If the name of the PivotField and the name of the field in the data source are different, the SourceName element must also be used. Specifies the group to which mapped PivotItem belongs. Contains a number indicating what PivotItems to display based on the values of the PivotItems. Used in conjunction with AutoShowField, AutoShowRange and AutoShowType. Specifies the name of the PivotField in the data area of the PivotTable report from which to get the PivotItem value to be used when determining whether a PivotItem should be displayed or not. Used in conjunction with AutoShowCount, AutoShowRange and AutoShowType. Contains an enumeration indicating which range of values to use in determining whether a PivotItem should be displayed or not. Used in conjunction with AutoShowCount, AutoShowField and AutoShowType. Contains an enumeration indicating whether all PivotItems are displayed for a PivotField or whether the PivotItems displayed are based on the value falling within a user-specified range. Used in conjunction with AutoShowCount, AutoShowField and AutoShorRange. Contains an enumeration indicating how PivotItems, for this PivotField, are sorted in the PivotTable report. Used in conjunction with AutoSortField. Specifies the name of the PivotField being used to determine the sort order of the PivotItems in this PivotField. Specifies the name of the PivotField that this PivotField is derived from. Used for PivotFields in the data area and for PivotFields that have had their PivotItems grouped. Specifies the name of the PivotItem that this PivotField is derived from. Used for PivotFields in the data area for certain calculation types. Used in conjunction with BaseField and Calculation. Specifies that a blank line is to be inserted after each change in value. Contains an enumeration indicating the type of calculation being done for the PivotField that is in the data area of the PivotTable report. Contains a Boolean indicating that a list of unique items from the data source for this PivotField was unavailable. Specifies the size of the groups for PivotItems when PivotItems have been grouped. Used in conjunction with GroupStart, GroupEnd, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField. Indicates the first PivotItem of the first group when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField. Indicates the last PivotItem of the last group when PivotItems have been grouped. Used in conjunction with GroupBy, GroupStart, GroupStartAuto, GroupEndAuto, GroupType, ParentField and BaseField. Indicates that the first PivotItem of the first group should be picked automatically when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupEndAuto, GroupType, ParentField and BaseField. Indicates that the last PivotItem of the last group should be picked automatically when the PivotItems of a PivotField have been grouped. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupStartAuto, GroupType, ParentField and BaseField. Contains an enumeration that indicates how the PivotItems of this PivotField are grouped. A Boolean indicating that a page break should be placed after each change in value for this PivotField. Specifies the display formatting to use when displaying the PivotItem or aggregate value. Specifies the name of the PivotField that is the parent (one level up) of this lower-level grouped PivotField. Used in conjunction with GroupBy, GroupEnd, GroupStart, GroupStartAuto, GroupType, GroupEnd and BaseField. Specifies the field in the data source that the PivotField represents. Not required if the name element of the PivotField matches the field name in the data source. Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden. Contains an aggregation to be performed to calculate the value in the cell. Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types. Specifies how items appear in a PivotTable report. Specifies where subtotals are displayed in a PivotTable report. Specifies that the field cannot be dragged to create column headers. Specifies that the field cannot be dragged to create row headers. Specifies that the field cannot be dragged to the data area. Specifies that the field cannot be dragged out of the pivot area. Specifies that the field cannot be dragged to the page area. Contains additional information (member property information) about a field in OLAP-based PivotTable view or report. Specifies the order of a member property if a cube field is associated with multiple OLAP member properties. Contains a Boolean value indicating whether the drop-down list for a field in the PivotTable view should be shown. Contains a Boolean that indicates for a PivotField in an OLAP-based PivotTable whether this PivotField was shown due to the user navigating down an entire hierarchy level. Contains a Boolean that indicates for a PivotField in an OLAP-based PivotTable whether the order of the PivotItems comes from the server or is determined by Excel. Contains a Boolean value indicating whether OLAP member property information is displayed for a field. Specifies the name of the PivotItem selected for this PivotField when the PivotField is in the page area. Specifies the display text or caption for a PivotField in an OLAP-based PivotTable. Contains information about OLAP cube members that are selected when an OLAP hierarchy is shown in the page area of the PivotTable view. Specifies a unique name for a OLAP cube member. Contains the zero-based level index on which an OLAP cube member resides. Specifies a caption for the OLAP cube member. Specifies the order of the fields when several PivotFields are used. Specifies the data type of the field. Contains a Boolean indicating whether the server is queried every time the user changes the selected PivotItem for the PivotField that is in the page area. Contains a Boolean indicating whether all PivotItems should be shown or not even if they have no data. Specifies the data type using SQL Server data types. Specifies the custom text to display for the subtotal label for this PivotField. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. Specifies the text formatting that is applied to a field when it is on the detail grid. Specifies the width of a field (in pixels) when it appears on the detail axis. Specifies whether the field members are expanded by default, or whether a leaf member was expanded. Contains the caption of a field set when the field set is the current filter. Specifies the formula used to calculate the values for a PivotField in the data area. Contains the string of the Formula element with English locale. This string is generated only generated when the English version of the Formula string is different from the string in the Formula element. Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula). Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis. Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed. Specifies the contains the caption of a PivotList field. Specifies whether a field is on the detail grid. Specifies whether a field is the Weeks field of a weekly automatic date field set. Contains the name of a total when a PivotField element represents a total. Specifies the position of a field in the detail grid. Contains the subtotal to display when a PivotTable field is not on the column or row axis. Specifies the name of the hierarchy this PivotField belongs to in an OLAP-based PivotTable. Contains an index of the hierarchy level to which a particular OLAP member property applies. Specifies a number indicating what level in the hierarchy this PivotField belongs to in an OLAP-based PivotTable. Contains information on an item (PivotItem) in the PivotField. Specifies the text formatting that is applied to a subtotal. Specifies the horizontal alignment of a total. Specifies the horizontal alignment of the caption for a total. Specifies the width of a total and whether the width is automatically set. Contains the index position of a PivotTable field within its current orientation, or specifies the position of a PivotTable field on an axis, the position of a chart title or data label, or the base position of a label entry. Specifies how items appear in a PivotTable report. Specifies how items appear in a PivotTable report. Specifies the text formatting that is applied to a field when it is on the detail grid. Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field. Specifies the number format to apply to data field items and totals. Contains information on an item (PivotItem) in a PivotField. 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. Specifies a formula used to set the value of the PivotItem. Contains the string of the Formula element with English locale. This string is generated only generated when the English version of the Formula string is different from the string in the Formula element. Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula). Specifies the order in which formulas are to be calculated for PivotItems that use multiple formulas. Specifies that the item is to be hidden. Contains a Boolean indicating if detail data should not be shown for this PivotItem. Contains a Boolean indicating whether or not the PivotItem is currently used in the data source. Indicates what data source item this PivotItem maps to in a PivotField that has been grouped. Specifies whether the PivotItem element contains the name of a member instead of another string or value. Specifies the name of the item in the data source that data is to be drawn from. Required only when the value of the Name element is different from the name of the item in the data source. Contains a boolean value that indicated that the user has drilled down on an OLAP based PivotTable. Contains information on a PivotTable. Specifies the name of the PivotTable. Contains a Boolean value indicating that the user is allowed to edit the cells in the data area of the PivotTable view or report. Describes the properties of the query table on which a PivotTable view or report is based. Specifies the string to display in cells with errors. Used in conjunction with DisplayErrorString. Specifies the string to display in cells with no value. Used in conjunction with NoDisplayNullString. Contains an enumeration indicating how the page fields are laid out when there are multiple PivotFields in the page area. Specifies a number indicating how many page fields to display before starting another row or column. Contains a Boolean indicating if the user is prevented from drilling down (double clicking) on a PivotItem or aggregate value. Contains a Boolean indicating if the user is prevented from displaying the PivotField properties dialogs. Contains a Boolean indicating if the user is prevented from displaying the PivotTable Wizard. Causes the ErrorString to be displayed. Used in conjunction with ErrorString. Contains a Boolean indicating whether the formatting applied by the user to the PivotTable cells is discarded on refresh. Contains a Boolean indicating whether autoformatting has been applied to the PivotTable view. Used in conjunction with AutoFormatName, AutoFormatNumber, AutoFormatBorder, AutoFormatPattern, AutoFormatAlignment and NoAutoFormatWidth. Specifies that data for hidden PivotItems for PivotFields in the data area are not excluded from subtotals. Specifies that column widths from the style specified in the AutoFormatName element are not to be applied. Contains a Boolean indicating if no grand totals should be displayed for the PivotTable rows. Contains a Boolean indicating if no grand totals should be displayed for the PivotTable columns. Contains a Boolean indicating whether the custom NULL string should not be displayed. Used in conjunction with NullString. Contains a Boolean indicating whether PivotItem names should be repeated at the top of each printed page. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. Contains information about the current PivotTable selection. Specifies that alignments from the style defined in the AutoFormatName element are to be applied. Specifies that border settings from the style defined in the AutoFormatName element are to be applied. Specifies that fonts from the style defined in the AutoFormatName element are to be applied. Specifies the name of the built-in format to be applied. Specifies that number formatting from the style defined in the AutoFormatName element is to be applied. Specifies that the pattern from the style defined in the AutoFormatName element is to be applied. Specifies the string to be displayed for grand totals. Specifies the row and column titles from the PivotTable to be printed (rather than the titles from the spreadsheet). Specifies that row or column titles that span multiple cells should be merged into a single cell. Specifies the name of the Excel style to apply to each of the PivotField-PivotItem headers displayed in the page area. Contains a Boolean indicating whether the PivotTable was created by the Office Web Components PivotList control. Specifies that the PivotTable view is to be immediately updated when new items are dropped into it. Specifies the text to display for the PivotItem header in the page area when two or more PivotItems, but not all PivotItems, have been selected. Contains a Boolean indicating if a PivotTable view without a data field should show the small grid, which doesn't have very big drop areas. Specifies the name of the Excel style to apply to the main table area of the PivotTable. Specifies a user-defined string that is associated with this PivotTable. Specifies the name of the Excel style to apply to the cells left blank when a PivotTable shrinks during a refresh operation. Specifies that asterisks be displayed in subtotals and totals when visual totals are not used in OLAP-based PivotTable views. Contains a Boolean value indicating that a PivotTable based on an OLAP source should format the data and aggregate cells in the PivotTable view using the background color from the OLAP source. Contains a Boolean value indicating whether the drop-down lists for the fields in the PivotTable view should be shown. Contains a Boolean value indicating whether calculated members should be hidden in a PivotTable view or report. Indicates that totals should be based on visible data only for OLAP-based PivotTable views. Specifies the bounding cell reference the PivotTable occupies including the page area. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. Specifies whether the data source of a PivotList component is data from Microsoft Excel that was saved to a Web page or data from a Data Source Control component. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. Contains a Boolean indicating that the PivotField list window should not be shown. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components. Specifies additional information about a PivotTable axis or location. Contains a number indicating the earliest version of Excel that can update this PivotTable view. Contains a number indicating which version of Excel last updated this PivotTable view. Contains a number indicating the earliest version of Excel that can refresh this PivotTable view. Contains a number indicating what version of Excel was used to create this PivotTable view. Contains information about a PivotField. Contains information about a cube field (a hierarchy in an OLAP-based PivotTable view). Contains information about a calculated member in an OLAP-based PivotTable view or report. Specifies the name of the OLAP calculated member. Specifies a caption (display name) for the custom OLAP calculated member (not used for sets).