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
http://www.contextures.com/xlPivot07.html
Doug Muegge wrote:
> 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" wrote:
> .
>
Doug Muegge wrote:
> 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.
--