Pivot Table: Cannot group that selection

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot ungrouping on refresh? 3
Group in Multiple Pivot table 1
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
date filter in a pivot table 1
pivot table data 2
Grouping dates in pivot table 3
Grouping in a Pivot Table 1
Pivot table wizards 2

Back
Top