Allow users to disable date grouping in PivotTables
Please make functionality "improvements" with the ability to choose when to use them. Excel now "auto-groups" certain data in pivot tables. I don't need or want this most of the time, but I can't turn it off. Now I'm in a bind where I need to process several reports and have to figure out how to work with this new forced "enhancement"
Good news – this is already supported in Excel. To turn off Date Grouping in PivotTables, go to File > Options > Advanced, scroll down to the “Data” section, and toggle the “Disable automatic grouping of Date/Time columns in PivotTables.”
8 commentsComments are closed
Frustrated Long-time Excel User commented
That only works for Windows. How do I disable it on Excel for Mac? I already tried deselecting "Group dates when filtering" in Preferences -> Tables & Filters, but the same pivot table is STILL breaking the date out into "Years, Months, Date" (why "Date" and not "Day" - weird).
Irritated Excel User commented
The suggested solution doesn't fully solve the problem. Even after selecting “Disable automatic grouping of Date/Time columns in PivotTables”, DATA IS STILL GROUPED AT MONTH LEVEL, even when the underlying column has day level data. This is extremely bad design. Is there a way to get day level data in excel pivots??
Thank you. The introduction of new features of such an impact should not be done without proper way to enable/disable them. More over, this particular one should not be hidden in Advanced options but in at hand in object (pivot table) properties. I have spent precious time searching how to manage Excel to behave as used to.
Sigh, what a glorious example of completely senseless MS software designers finding yet another way of frustrating the poor souls who are at the mercy of their stupidity of thinking they are smarter than most with these kind of "enhancements". WTF, Why why why?????
I agree, enhanced functionality should be an 'opt-in' setting when updating to new versions of the software. Finding these surprise enhancements during analysis, and then having to work around or scour the internet to disable them is exhausting. Try to design your product as a "means to an end" software- I can't spend all day revisiting and executing basic features, when I have other stuff to do.
Mr. Stein commented
This is the most irritating "enhancement" I've yet experienced. I have to come here to learn how to stop excel from forcing my pivot tables with dates given as rows so I could look at data at the daily level. You're giving enhancements a bad name.
I have the latest version of excel 2016, and that option does not exist to disable automatic grouping of Date/Time columns in PivotTables. Also, prior to 2016, group by Date adding month showed the number. No MS has force the use of a 3 character abbreviation which cannot be changed. Our staff is up in arms over this one. In their mind totally destroyed excel for them.