PivotTable.FieldListSortAscending Property
Controls the sort order of fields in the PivotTable Field List. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property FieldListSortAscending As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.FieldListSortAscending
instance.FieldListSortAscending = value
bool FieldListSortAscending { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
When this property is set to True, the fields are sorted in ascending order. When it is set to False, the fields are sorted in data source order.
Does not apply to PivotTable connected to OLAP data sources.