| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Error on grouping
Keep getting a "Cannot group that selection" when trying to group dates
by month in a pivot table. Dates are formatted correctly in the data table. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error on grouping
If you have any non-date cells in that range--including empty cells or text
cells, you'll get this error. And is there any chance that your pivottable uses too many rows--maybe you included empty cells at the bottom of the data? wrote: Keep getting a "Cannot group that selection" when trying to group dates by month in a pivot table. Dates are formatted correctly in the data table. Any ideas? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
blanks in range
I normally get this when there are blank cells in the column or range selected.
Very annoying. You may need to put a nil value into empty cells. EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table grouping excluding weekends | Excel Discussion (Misc queries) | |||
| excel should allow me Indian number grouping ##,##,##,###.## | Excel Worksheet Functions | |||
| How do I get the grouping dialogue box to appear in Pivot Tables? | Excel Worksheet Functions | |||
| How to display excel's grouping data in HTML??? | Excel Discussion (Misc queries) | |||
| Grouping | Excel Discussion (Misc queries) | |||
Linear Mode
