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

TJ wrote:
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?


"Ron Coderre" wrote:


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


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

XL2003, WinXP


"Marion" wrote:


Tks found the error, was a setting of date

"Ron Coderre" wrote:


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


"Marion" wrote:


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.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com