Disable Grouping of Dates in Excel Pivot Tables

[Mvaldesi]

Good morning, Experts and Gurus,

A while back, I figured out how to “turn off” the auto-grouping of dates in my Excel pivot tables by default, i.e.: when I drop in a date field, it automatically lists each unique date as opposed to collapsing them into “Year-Quarter-Month.” Now, a co-worker of mine wants her Excel to default similarly… but I can’t recall how I did it. Seems like it would have been a simple pivot table option under the Advanced options tab (at least that’s where my meager intellect would have taken me,) but I don’t see it. Little help, please? Thanks in advance! Oh, we're using Excel 2016, by the way.

[CK76]

One way is to edit registry key. See article below for details.
https://support.office.com/en-us/art...7-5ac262d67b3f

This is only available for Excel 2016. (If using Office 365 subscription, you may find option in File->Options->Data without registry edit).
0.JPG

[Mvaldesi]

Ugh, thank you! I knew it was that simple; I don't know how in which world I missed it! I swear I looked.