| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cannot Group that Selection error in PivotTable
I am trying to group dates in a PivotTable column and receive an error that I
"Cannot Group that Selection". I have checked to make sure that all the data fields are formatted as dates. Any suggestions on how to get past this error? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cannot Group that Selection error in PivotTable
Check out this link...
http://www.contextures.com/xlPivot07.html#Problems If your data was originally not dates when you created the pivot table and then you subsequently changed the source data to actual dates, you need to refresh the pivot table twice for the change to take effect. Other than that just double check that ALL of your dates are true dates and that there are absolutely no blanks or such... -- HTH... Jim Thomlinson "CherylS" wrote: I am trying to group dates in a PivotTable column and receive an error that I "Cannot Group that Selection". I have checked to make sure that all the data fields are formatted as dates. Any suggestions on how to get past this error? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table cannot group selection | Excel Discussion (Misc queries) | |||
| cannot group that selection | Charts and Charting in Excel | |||
| PivotTable Group by Week and Month | Excel Discussion (Misc queries) | |||
| Calculation of Selection Group using Arrays (or VBA?) | Excel Worksheet Functions | |||
| Cannot Group that selection Problem | Excel Discussion (Misc queries) | |||
Linear Mode
