Pivot Tables.

DoubleB · Apr 7th 2003

When running a Pivot Table, the Rows and Columns automatically alpha sort. I want it to stay in the format I set ie not alpha sort. How do I achieve this?

Paddyd · Apr 7th 2003

Hi - welcome to the board.

see the help file for:

'Sort data in a PivotTable or PivotChart report'

...it is possible to define a custom sort order for your pivot table.

DoubleB · Apr 7th 2003

Thanks, but I don't want to resort it. My aim is to have it display in the format that I have the table set in ie adhoc, not alpha.

It's a fun game isn't it.

Dave Hawley · Apr 7th 2003

Hi DoubleB

In our new Microsoft ® Links section there is a list of links to Pivot Tables, see Pivot Table Links then follow the link to: HOW TO: Custom Sort or Prevent Auto Sort in PivotTable in Excel 2000

Pivot Tables.

Participate now!

Share