LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering by criteria within Pivot Tables in Excel 2000 Sardonic Excel Discussion (Misc queries) 0 December 4th 07 02:55 PM
Recommondation for training sites for Pivot Tables in Excel 2000? GinaS. Excel Worksheet Functions 4 November 9th 06 01:22 AM
Sorting in Excel 2000 Pivot Tables LPS Excel Discussion (Misc queries) 1 December 8th 05 08:25 PM
Pivot Tables in Excel 2000 LPS Excel Discussion (Misc queries) 1 December 8th 05 06:43 PM
How can I delete rows from Pivot Tables in Excel 2000 as in 97 Rex at B$4U Excel Discussion (Misc queries) 0 April 18th 05 04:55 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"