Cannot group that selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often get the "Cannot group that selection" error when working with pivot
tables in Excel and trying to group data by month, quarter, year etc. The
Knowledge base says to remove blank lines from the data. I've tried this, as
well as removing all blank cells, but still get the same error.
 
In a list of dates you must ensure that you have no blanks and no text
values. EVERY value in that field must contain a valid date if you are to
group.

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

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