pivot table cannot group selection

[Guest]

I am working in a pivot table, dragged my dates in from source data and want
to group, it gives me error message " cannout group selection". I took out
all blanks. Will not even give me the option to choose month, year,etc.

 

[Guest]

If Excel can recognize the values as dates, you'll get the grouping optons.

Post a sample of your "dates". Perhaps we'll spot an issue.


***********
Regards,
Ron

XL2003, WinXP

 

[Guest]

Tks found the error, was a setting of date

If Excel can recognize the values as dates, you'll get the grouping optons.

Post a sample of your "dates". Perhaps we'll spot an issue.


***********
Regards,
Ron

XL2003, WinXP

 

[Guest]

I'm glad you figured it out......and thanks for the feedback.


***********
Regards,
Ron

XL2003, WinXP

 

[TJ]

Hi,

I'm having the same error :-(

I have tried the things suggestion in this trail but still am getting no
where.

Example of dates:

01/05/2009
08/05/2009
08/05/2009
08/05/2009
08/05/2009
08/05/2009
15/06/2009

Any help?

 

[Debra Dalgleish]

Check your pivot table source data range, and make sure that you haven't
included any blank rows at the end.

 

[Doug Muegge]

I am working in a pivot table and having the same issue. Keep geeting a
"cannot group that selection" error when I try to group dates. I have checked
for blank rows as suggested in this thread. Help!

 

[Debra Dalgleish]

There are a few other suggestions for fixing grouping problems here:

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

 

[Doug Muegge]

Thank you for the information - I have tried clearing all blanks and
converting dates based on your guidance. Apparently, I'm still not recogning
the issue - still getting error message "Cannot group that selection" -
extremely frustrating but, I'm not that skilled at Excel. Not sure what to do
next.

 

[Debra Dalgleish]

Did you check the pivot table source data to make sure that you didn't
accidentally include a blank row at the end of the table?