This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.
| Element |
Description |
| 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. |
| Formula |
Specifies a formula used to set the value of the PivotItem. |
| FormulaV10 |
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. |
| ParseFormulaAsV10 |
Specifies that the string in the Formula element is to be processed as if it is an English string (a V10 formula). |
| FormulaIndex |
Specifies the order in which formulas are to be calculated for PivotItems that use multiple formulas. |
| Hidden |
Specifies that the item is to be hidden. |
| HideDetail |
Contains a Boolean indicating if detail data should not be shown for this PivotItem. |
| Missing |
Contains a Boolean indicating whether or not the PivotItem is currently used in the data source. |
| CachePosition |
Indicates what data source item this PivotItem maps to in a PivotField that has been grouped. |
| Member |
Specifies whether the PivotItem element contains the name of a member instead of another string or value. |
| SourceName |
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. |
| DrilledMember |
Contains a boolean value that indicated that the user has drilled down on an OLAP based PivotTable. |
None.