Excel Pivot Table Date Grouping Not Working

Immediately press ctrl z to undo the automatic date grouping.

Excel pivot table date grouping not working.

Group field is always greyed out and the grouping pop up is not available as an option. The problem is i have no idea how i did this. Let s take a look at why this happens. Now to fix this you can simply use the filter button to find the cells containing incorrect format or text.

The simple rule for the enabling the group field feature for dates is. For excel 2013 and later there s another thing that can prevent you from grouping. In the right click menu click ungroup. At any time right click on any of the date field items or headings.

The group field button on the analyze options tab of the pivottable tools ribbon might be disabled or grayed out. The grouped fields are removed and the original date field remains in the pivot table. This means that there are non date entries in the date column. I am using excel 2010 and neither route works as neither of those choices is available.

The simple rule for grouping dates in pivot tables. Once you apply grouping then it will be available in future pivot tables you create using the same data. If you try to apply grouping to a date column you may get the following error message. The original table only has date not months.

When you try to group this data you will see that excel pivot table not grouping dates and will display this error. They generally talk about selecting the date column right clicking and selecting group and outline and then using a grouping pop up to select weeks or selecting the field and using the group field button in the pivot table tools option toolbar. Add the date field to the pivot table. Btw the way i have grouped the dates none of the entries are blank.

For older versions of excel if you had a problem grouping pivot table items it was usually caused by blank cells or text in number date fields. Add the date field to the pivot table. Pivot table date group by month does not work detlef lewin i was trying to apply your solution when suddenly the pivot table itself divided my date into months.