HiddenFields Property

HiddenFields Property

See Also         Example         Applies To

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

Syntax 1

expression.HiddenFields(Index)

Syntax 2

expression.HiddenFields

expression   Required. An expression that returns a PivotTable object.

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.