Re: Pivot Table Report formatting - can't select Data Source Order

The Data Source Order option applies to OLAP source data.

For pivot tables built from Excel data, the items are listed in Ascending order when the pivot table is created. If you don't want to sort the items manually, you could create a custom list, and base the sort order on that.

In a cell on a blank work***, 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, set them to automatic sort, or select the field button, and choose Data>Sort
Click the Options button, and choose your custom list.


Becky wrote:
Going a little bananas with trying to get a Pivot Table Report to accept the order of the fields as they are in the Pivot Table. It's importing them in ascending order by default, and I can't select Data Source Order from the toolbar's Sort and Top 10/AutoSort options. The "manual" selection is the default, but I don't want to have to drag every field around each time. What's up? 


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.