Excel 2007 : disable sorting in pivot table

**somedude** · 05-19-2010, 02:43 AM

Hi

I have a list of data which I use for a pivot table. However the pivot table sorts my data. I would like the data to be in the same order (unsorted). Is that possible?

**DonkeyOte** · 05-19-2010, 03:28 AM

set the Sort Order to Manual for the appropriate Fields.

http://office.microsoft.com/en-us/ex...029711033.aspx

If this is a 2007 question (forum says yes, profile implies otherwise):

http://office.microsoft.com/en-us/ex...759041033.aspx

**somedude** · 05-19-2010, 04:12 AM

Thanks for your answer.
I have updated my profile info. I use excel 2007.

However i don't get the following option:
"To return items to their original order, click Data source order. This option is only available for OLAP source data."

If I click the header the sort button is greyed out. If I mark one of the cells in the row it is possible to press the sort button but the option is missing. I get data from another worksheet and not a database.

**somedude** · 05-21-2010, 02:07 AM

Anyone...?

**somedude** · 05-26-2010, 04:22 AM

Or do I have to make an ekstra column with numbers that can be used as sorting parameter?

**VICHI** · 10-30-2011, 05:19 AM

have you got answer to this problem...i am facing
the same...pls share,if u have the solution...thank u

**ConneXionLost** · 10-30-2011, 07:42 PM

VICHI,

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.