Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Grouping difference between 2003 and 2007

In Excel 2003, when you right clicked a numeric field, and selected group...
you would be given a dialog where you could enter the start, end and
increment for the PivotTable.

In 2007, Group does not present any dialog, and instead complains that it
can not group the field. If the entire set of data is selected, it places it
into a single group.

Is there similar functionality in Excel 2007? How can you set up a group by
increment without doing the grouping by hand?

Reply
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
difference office 2003 and 2007 hisham Excel Discussion (Misc queries) 4 March 26th 09 02:01 PM
difference between exel 2003 and 2007 bench Excel Worksheet Functions 1 July 26th 08 03:32 PM
grouping error in Excel 2003/2007 Pivot table connect to offline c KT[_2_] Excel Worksheet Functions 0 June 4th 08 04:41 AM
Difference between Subtotals and Grouping Helen Excel Discussion (Misc queries) 3 August 13th 07 05:12 PM
difference between office 2003 and office 2007 alt+n Excel Discussion (Misc queries) 1 October 4th 06 11:54 AM


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