View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SnoHo71 SnoHo71 is offline
external usenet poster
 
Posts: 2
Default Ordering Columns in Pivot Tables - Excel 2000

I have a Pivot table consisting of 25 columns. I would like to customize the
sort order of the columns. Here is what I have tried thus far:
1) Dragging cells to order them. I get a pop up saying that the operation
can't be complete
2) Custom Sort. 23 of the 25 columns sort correctly. The problem is that
the columns that 2 columns that should be in the middle (should be columns 12
and 13) end up at the end (columns 24 and 25).

3) Using the order functionality. All options: Move to Begining, Move UP,
Move Down, Move to End are "greyed out" (unable to select).

Any advice is much appreciated. Thanks