Pivot Table: Cannot group that selection
 

I have a pivot table that will not allow me to group a date field. I have
verified that the dates are valid and that there are no blanks. Anything else
I can do?

Pivot Table: Cannot group that selection
 

You have hit on the big reasons why dates sometimes will not group. Check out
this link...

http://www.contextures.com/xlPivot07.html#Problems

To ensure that you truely have dates try re-formatting the dates to pick out
and dates that are something other than a date. Also ensure that your randge
does not extgend past the date range as that constitues blank cells. finally
if you did have a date that you needed to change from test or such to a date
then you need to refresh the pivot table twice. Long story made short the
table needs to be refreshed twice to recognize the change.
--
HTH...

Jim Thomlinson


"Jeff" wrote:

I have a pivot table that will not allow me to group a date field. I have
verified that the dates are valid and that there are no blanks. Anything else
I can do?