Syntax

expression.ShowPivotTableFieldList

expression A variable that represents a Workbook object.

Example

In this example, Microsoft Excel determines if the PivotTable field list can be shown and notifies the user.

Visual Basic for Applications 
Sub UseShowPivotTableFieldList() Dim wkbOne As Workbook Set wkbOne = Application.ActiveWorkbook 'Determine PivotTable field list setting. If wkbOne.ShowPivotTableFieldList = True Then MsgBox "The PivotTable field list can be viewed." Else MsgBox "The PivotTable field list cannot be viewed." End If End Sub
show pivot table field list showpivot showpivottable showpivottablefield showpivottablefieldlist showpivottablefieldlist property

See also: