Any chance you included too many rows (and have an empty cell in that field)?

If you delete the existing pivottable and recreate it, does it work ok?

Fred Smith wrote:

I have a table of bond maturity dates which I want to group by year.

When I create the pivot table, then try to Group the maturity date column, I get
the message "Cannot group that selection"

This normally happens if I have a non-date in the column of data, but I have
checked the data very carefully and am sure every cell is a valid date.

Is there anything else I can look for? If it means anything, the dates extend
out to 2053.

--
Regards,
Fred

--

Dave Peterson