Pivot table will not group a date field
 

I have a pivot table that I grouped the dates by month. I've been using it
for quite a while. I just refreshed it and the dates came ungrouped.And when
I select the date field and group, I get an error message saying "cannot
group that selection.

You either have blanks or text fields in your dates - Find and fix.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Mary" wrote in message
...
I have a pivot table that I grouped the dates by month. I've been using it
for quite a while. I just refreshed it and the dates came ungrouped.And
when
I select the date field and group, I get an error message saying "cannot
group that selection.

If you don't have blank cells or text in the date column, there may be a
grouped field left over from the previous time that you grouped the
data. Check the field list, to see if there's a second copy of the date
field, e.g. Date2.

If there is, add it to the row area, and ungroup it.

Then, you should be able to group the date field again.


Mary wrote:
I have a pivot table that I grouped the dates by month. I've been using it
for quite a while. I just refreshed it and the dates came ungrouped.And when
I select the date field and group, I get an error message saying "cannot
group that selection.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html