Pivot Table Sort Issue

[Passman]

I have a pivot table with 40 columns of data which I have sorted by column largest to smallest.

My problem is how to return the pivot table back to data source order. I am sure their is a very easy answer but having searched extensively this forum and the internet I am coming up with a blank. Any help is much appreciated.

 

[Stu Dapples]

I think it is a case of removeing the filter and refreshing the data... Try it, otherwise, you may have to redo the pivot from scratch and it will return to data order....

I am sure there is an option somewhere for remove sort, I will have a look but try these in the meantime.....