pivot table in data source order

M

Murray

My pivot table report automatically sorts the data, rather than keeping it in
data source order, which is what I want.

I click on the "Manual" option in the advanced section to no avail. The
option button that says "Data source order" is greyed out so I cannot select
that option. I am using Excel 2002
 
D

Debra Dalgleish

AFAIK, the Data source option is only enabled for OLAP cubes. For pivot
tables built from Excel data, the items are listed in Ascending order
when the pivot table is created. If you set sort to Manual, you can drag
the items to any position in the list.

You could also create a custom list, and base the sort order on that.

In a cell on a blank worksheet, type your list, then select it
Choose Tools>Options
Select the Custom Lists tab
Click the Import button, click OK

When you create a new pivot table, items should be in the order of the
custom list.

To sort the items in an existing pivot table, select the field
button, and choose Data>Sort
Click the Options button, and choose your custom list.
 
Top