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.