Excel.PivotTable.EnableFieldList.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.EnableFieldList property (Excel)	vbaxl10.chm235148	vbaxl10.chm235148	Excel.PivotTable.EnableFieldList	3f078d19-d2ec-1c1a-e039-69e8d7e21e95	05/08/2019	medium

PivotTable.EnableFieldList property (Excel)

False to disable the ability to display the field list for the PivotTable. If the field list was already being displayed, it disappears. The default value is True. Read/write Boolean.

Syntax

expression.EnableFieldList

expression A variable that represents a PivotTable object.

Example

This example determines whether the field list for the PivotTable can be displayed and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub CheckFieldList() 
 
 Dim pvtTable As PivotTable 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 
 ' Determine if field list can be displayed. 
 If pvtTable.EnableFieldList = True Then 
 MsgBox "The field list for the PivotTable can be displayed." 
 Else 
 MsgBox "The field list for the PivotTable cannot be displayed." 
 End If 
 
End Sub

[!includeSupport and feedback]