disable automatic grouping of dates and times
This issue is far from resolved. MS before closing this item consider that (arrogantly speaking for the community)
- auto grouping should be disabled by default
- should be configurable at the app level not workbook
Leave the item open for user community to comment against until such time that the manager that OK'd this has been burned at the stake for being so arrogant as to assume the general community wants/ed this.
It is hard enough to get people moving in the right direction with data without you making such transitions HARDER not easier. WYSIWYG, I asked for 1 column not 3 and a typical user is then forced to fight their way to the registry, total ****.
I agree. Date grouping should be optional. If you must make it a default, Make it EASY to disable. I've tried several times to disable date grouping but the fixes I've seen do not work! I'm working with Office 365 on an enterprise license. Just trying to get my preferred defaults to save is a pain.
This should be an OPTION not an unwanted default that does not go away immediately when I don't want it. M$ please stop making your products worse and taking away useful items to shove time wasters
My own personal work around is to click on the date and press "Shift+alt+left key".
Not perfect but makes life a little easier.
Irritated Excel User commented
Even after selecting “Disable automatic grouping of Date/Time columns in PivotTables” in File --> Options --> Data section, the issue remains unresolved. Data in pivot is still grouped in months instead of showing dates in MM/DD/YYYY format. This is what user Z has reported in his comment.
I found a workaround solution to this problem. Right click on the data in that pivot table, and select "Group", then select "Year, Quarter, Month, Day". This will group the data and show "+" signs to drill down. Now right click on the field and select "Ungroup". This will ungroup the data and disaggregate it to Day level (instead of default Month level).
If I were Satya Nadela, I would sack the Product Manager, who approved the "feature" of auto-grouping of data in pivot tables.
Agreed. this feature seems to turn on randomly in my pivot tables and the way to turn it off is not at all intuitive. I have to google it every time. It should be an app level setting that I can turn off.
While auto-grouping might be useful in some basic scenarios, it's causing more harm than good. Any analysis with fiscal calendars, specific dates comparison or time-stamp drill-down is much harder with this feature. Please enable configuration thru interface (I'd recommend disable by default).
I have been unable to disable this feature at the workbook level. Additionally, even when I manually remove the grouping, I am often unable to view my date values by day; the grouping remains in place (even after I've removed the 'year' and 'quarter' fields from the Field List) and will only display data grouped by month, even though my date values range from 12/25/2017 to 1/2/2018. I would concur with other users that this should never be a default feature; the unintended effects of this update to pivot table functionality has been a major obstacle for me ever since I updated.
It should definitely be configurable through the interface or some settings. One should not have to resort to the registry for this level of control.