PivotTable.HiddenFields Property

Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of all the fields (a PivotFields object) that are currently not shown as row, column, page, or data fields. Read-only.

Syntax

expression.HiddenFields(Index)

expression   A variable that represents a PivotTable object.

Parameters

Remarks

For OLAP data sources, this property always returns an empty collection.

Example

This example adds the hidden field names to a list on a new worksheet.

  Set nwSheet = Worksheets.Add
nwSheet.Activate
Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable
rw = 0
For Each pvtField In pvtTable.HiddenFields
    rw = rw + 1
    nwSheet.Cells(rw, 1).Value = pvtField.Name
Next pvtField

See Also

• PivotTable Object
• PivotTable Members
• ColumnFields Property
• DataFields Property
• PageFields Property
• PivotFields Property
• RowFields Property
• VisibleFields Property