Pivot Table: Cannot group that selection

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

Jim Thomlinson

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 table cannot group selection 9
Grouping daily transactions in a pivot table by month - CANNOT GROUPTHAT SELECTION ERROR 1
date filter in a pivot table 1
Creating auto Updating Pivot Table linked to external data. 1
Pivot table wizards 2
Grouping in a Pivot Table 1
Pivot Table - Group by Date Excel 2007 1
Grouping dates in pivot table 3

Top