| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am getting an error when I try to group data in a pivot table.
I have been working with the same data fields for weeks, pasting in new data
and refreshing my data source ranges. I have been able to group dates in my data, but now today I am not able to group my dates. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am getting an error when I try to group data in a pivot table.
If you have any text (or blanks) in that field, then you won't be allowed to
group it. If you're positive that there are no blanks/text in that field, then you may want to rebuild the pivottable. Sometimes, xl "knows" that there are non-dates in the field, even when I can't find any! And in cases like that, excel wins (even if it's wrong!). BFOR wrote: I have been working with the same data fields for weeks, pasting in new data and refreshing my data source ranges. I have been able to group dates in my data, but now today I am not able to group my dates. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am getting an error when I try to group data in a pivot tabl
That was it.
Thanks so much!!! "Dave Peterson" wrote: If you have any text (or blanks) in that field, then you won't be allowed to group it. If you're positive that there are no blanks/text in that field, then you may want to rebuild the pivottable. Sometimes, xl "knows" that there are non-dates in the field, even when I can't find any! And in cases like that, excel wins (even if it's wrong!). BFOR wrote: I have been working with the same data fields for weeks, pasting in new data and refreshing my data source ranges. I have been able to group dates in my data, but now today I am not able to group my dates. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table - show top 20 and group remaining data | Excel Discussion (Misc queries) | |||
| How do you group data in a Pivot Table? | New Users to Excel | |||
| Why does the pivot table not allow me to group data? | Excel Discussion (Misc queries) | |||
| Pivot table/chart - can I use data ranges? why will it not group d | Charts and Charting in Excel | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Linear Mode
