How do I stop a Pivot Table from Sorting my data (Excel 2007)

N

NickH

The data in my Access database is in the order that I want it to be
but my Pivot Table insists on sorting it either Ascending or
Descending. I can't seem to turn this off...

If I right-click on the field name and choose Sort > More Sort
Options... > Manual (you can drag items to rearrange them) This
makes no difference!

If I choose PivotTable Options > Display > Field List: Sort in data
source order This again makes no difference!

Is there some trick I'm missing or is it simply impossible to preserve
the original data source order?

Br, Nick.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Data Column Sort Excel 2007 1
Excel 2007 pivot table using analysis services cube as data source 0
Sorting multiple columns (fields) in a pivot table 1
Pivot table not sorting 2
Problem with multiple sorting of fields in Pivot table 0
Pivot table drill down data 2
Pivot Table sorting 1
Pivot Table Sort 0

Top