Workbook.ShowPivotTableFieldList Property (Excel)
True (default) if the PivotTable field list can be shown. Read/write Boolean.
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.
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