LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Question Excel2007 pivot table page field

My database is fairly large, and thus the pivot table page field contains a list of close to 100 items; therefore, sorting (alphabetically) is almost a MUST.

The menu appearing by right-clicking on the page field gives access to the Field settings menu, and in Excel2003 this menu contains an Advanced... button that leads to a menu that contains sorting options.

But in Excel 2007 Pro there is no such a button and I neither found any other possibility to sort the page field.

Very curious to learn, if anybody can help me out. Many thks in advance.
Aad
 
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
How do I delete All from the page field of a pivot table? lmkatz Excel Discussion (Misc queries) 0 January 23rd 09 02:24 AM
Pivot Table Page Field Nate Excel Discussion (Misc queries) 4 December 24th 07 03:11 PM
Page field - pivot table yshridhar Excel Discussion (Misc queries) 0 August 1st 07 04:48 AM
Pivot Table Page Field Neily Excel Discussion (Misc queries) 3 February 24th 05 01:23 PM
Pivot Table Page Field Jimbola Excel Discussion (Misc queries) 0 February 6th 05 09:13 PM


All times are GMT +1. The time now is 01:23 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"