Hi,
Property ‘EnableFieldList’ related to the property ‘ShowPivotTableFieldList’ in Excel and It’s able to on/off field list instead of enable/disable.
Excel Developer Reference:
1. Workbook.ShowPivotTableFieldList Property
True (default) if the PivotTable field list can be shown. Read/write Boolean.
2. PivotTable.EnableFieldList Property
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.
I used these macro to change properties:
Sub RestrictPivotTableFieldList()
With ActiveSheet.PivotTables(1)
.EnableFieldList = False 'Excel 2002+
End With
End Sub
Sub AllowPivotTableFieldList()
Dim pt As PivotTable
Set pt = ActiveSheet.PivotTables(1)
With pt
.EnableFieldList = True 'Excel 2002+
End With
End Sub
Sub showFieldList()
ActiveWorkbook.ShowPivotTableFieldList = True
End Sub
Sub hideFieldList()
ActiveWorkbook.ShowPivotTableFieldList = False
End Sub
I use Aspose.Cells v7.0.3.2.
Best regards,
Alex Shloma