| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table cannot group selection
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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! -- Doug M "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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
There are a few other suggestions for fixing grouping problems he
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 Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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. -- Doug M "Debra Dalgleish" wrote: There are a few other suggestions for fixing grouping problems he 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 Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com . |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pivot table cannot group selection
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? 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. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to group a pivot table | Excel Discussion (Misc queries) | |||
| "Cannot Group That Selection" in a Pivot Table. | Excel Discussion (Misc queries) | |||
| Pivot Table, can't group | Excel Discussion (Misc queries) | |||
| pivot table selection | Excel Worksheet Functions | |||
| Pivot Table - no group on web | Excel Discussion (Misc queries) | |||
Linear Mode
