Syntax

expression.HiddenFields(Index)

expression A variable that represents a PivotTable object.

Parameters

Name Required/Optional Data Type Description
Index Optional Variant The name or number of the field to be returned (can be an array to specify more than one field).

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.

Visual Basic for Applications 
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
Get a list of all hidden fields in pivot table? hidden hidden fields Hidden Fields Property HiddenFields HiddenFields Property

See also: