Cannot Group that Selection error in PivotTable

C

CherylS

I am trying to group dates in a PivotTable column and receive an error that I
"Cannot Group that Selection". I have checked to make sure that all the data
fields are formatted as dates. Any suggestions on how to get past this error?
 
J

Jim Thomlinson

Check out this link...

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

If your data was originally not dates when you created the pivot table and
then you subsequently changed the source data to actual dates, you need to
refresh the pivot table twice for the change to take effect.

Other than that just double check that ALL of your dates are true dates and
that there are absolutely no blanks or such...
 

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

Top