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.
|