Remove sort order
Removing ascending or descending sort order will return the data either to its natural order, or if a custom order was specified, to the custom order.
- Click the Sort Ascending button
or the Sort Descending button
on the PivotTable list toolbar so that the button is not selected.