property Pivot.DisplayPivotFields as Long
Retrieves or sets the maximum number of columns to be displayed on the control's list.

TypeDescription
Long A Long expression that specifies the number of columns to be to be added during the execution of the current layout. If negative all executing columns are shown in the control's list
By default, the The DisplayPivotFields property is 256. The DisplayPivotFields property specifies the number of maximum columns to be added during the execution of the current layout. The DisplayPivotData property retrieves or sets the maximum number of rows to be displayed from the pivot's data. For instance, this property is useful to limit the columns to be added to the control's list, when you are grouping more columns, which can generate a lot of columns to be shown. This property prevent showing all of them during executing of the layout. The PivotColumns property indicates the list of data columns to be shown on the control's list. The DisplayPivotRows property retrieves or sets the maximum number of rows to be generated on the control's list.