Hi Bill,

I hate when this happens.

It's usually due to a null value on the date field. Excel won't group on a
field with a null.

I suggest that you start another pivot table from scratch (because you will
already have stored a null date in the existing pivot table's cache) and
pull in the data using a criterion that avoids a null date. BTW, it's best
to start with the field that you want to group as a row field.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Bill B" <Bill wrote in message
...
I am trying to take a field column of dates and group them into months.
The
message I get is cannot group that selection. My interpretation of help on
this subject is that it should work.