If you right-click on the field heading button, and choose Group and
Show Detail Group, you should see the dialog box.
If you have multiple cells selected, and right-click on those cells, it
will group those items without showing the dialog box.

jessica.lalonde wrote:
Hello,

I am using Pivot Tables in Excel. I am trying to group my data (which I can
do), but the Grouping dialogue box does not appear. It just groups the data -
creating a another field (column) with the grouping. I would like to specify
the grouping range and not have to do it manually!

~jess


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html