Pivot Table Sort Issue

Passman

Board Regular
Joined
May 23, 2007
Messages
103
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.
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Stu Dapples

Active Member
Joined
Jan 12, 2009
Messages
252
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.....
 

Watch MrExcel Video

Forum statistics

Threads
1,108,810
Messages
5,525,008
Members
409,615
Latest member
papaluigi94

This Week's Hot Topics

Top