How can we improve Excel for Windows (Desktop Application)?

Disable time grouping

The new automatic time grouping in PivotTables should be an option within Excel. Users should not need to make a registry edit to disable this feature, and the time grouping should not be on by default.

10 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    AndyAndy shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    completed  ·  Dan Battagin [MS XL]AdminDan Battagin [MS XL] (Admin, Office.com) responded  · 

    Hi all,

    This ability to turn off time grouping from the UI was recently added to the O365 version of Excel. File→Options→Advanced→Data→“Disable automatic grouping of Data/Time columns in PivotTables”.

    We’re considering adding this back to the perpetual release of Office 16. Until that’s available, you can also turn it off manually using the registry, outlined in this article: https://support.office.com/en-us/article/Turn-off-time-grouping-in-PivotTables-in-Excel-2016-for-Windows-6be5afed-348c-4db2-9f87-5ac262d67b3f.

    Regards
    Ashvini Sharma [MS]

    30 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        This needs to be an option you can change for each pivot table. The date grouping is very annoying some

      • Michael WoodMichael Wood commented  ·   ·  Flag as inappropriate

        Hate this feature and to have to go into the registry to try and turn it off is horrible. I work in a higher ed institution and need to be able to group dates into specific semesters which I can no longer do in my Pivot table. I have to create a dummy variable with a bunch of nested if statements in the raw data to use my downloaded data. What a waste of my time when it used to be so much easier.

      • Anonymous commented  ·   ·  Flag as inappropriate

        Microsoft: Please do not add features that users cannot opt out of. Taking control from users over their models' functionality is never a good idea and cannot possibly be in the best interest of the user.

      • Harry FlashmanHarry Flashman commented  ·   ·  Flag as inappropriate

        I hate this "feature" too. Killed the performance of my workbook. The option to disable this does not appear to be in my registry either (but perhaps that is because I am using 64 bit Excel). I won't be able to use Excel 2016 until this feature is changed to "opt-in" rather "opt-out" by tweaking registry settings (which will be a major hassle for the majority of business users who don't have admin rights).

      • Kok KiangKok Kiang commented  ·   ·  Flag as inappropriate

        Can't find this path: File→Options→Advanced→Data→“Disable automatic grouping of Data/Time columns in PivotTables”.

      • AkmialraAkmialra commented  ·   ·  Flag as inappropriate

        I went to the path you mentioned and it's disable, what happens when on the pivot you put the date on the row field and it also adds the month like by default and a different date format like 1-Jan instead of the original source 1/1/2017 and the format date doesn't change it.

      • DanDan commented  ·   ·  Flag as inappropriate

        Hi Ashvini,
        I can't see it in my Excel 2016. I'm also concerned that this feature is significantly increasing size of my data model (by around 30% -> 1.2 MB out of 4.0 MB). I think such a feature should be set to off by default, you should not be forcing the users how they want to display the data...

      • Anonymous commented  ·   ·  Flag as inappropriate

        Thanks for jacking up my files and crashing my machine. Opt in is the way to go. This forced improvement just corrupted one of my files.

      • Jonathan FlintJonathan Flint commented  ·   ·  Flag as inappropriate

        Thanks, Ashvini Sharma on an answer, unfortunately this reinforces for me why I did not want to upgrade to Office 2016 to begin with. Now I get to take much longer to do standard works because I have to figure out how to do the same work with new Microsoft Software.

        Warning Rant! - Microsoft when will you stop "doing us favors". To turn on and force us to have Time grouping on is very presumptuous and now forcing me to un-adopt Office 2016. I have many jobs I have to do that the customer [others in my company] need output by date and to have it broken down into Year, Qtr,..etc. is completely useless. To come here and find out I need to edit the registry on a new machine with new software on the first task because someone at Microsoft thinks they know best how to handle my data is ridiculous.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I hope people at Microsoft read this thread. After new year, any date range that include both 2016-2017 will automatically be grouped into year - quarter - month, with the actual date taken away. That is literally the dumbest feature that has ever been added to Excel

      • Chris SadlerChris Sadler commented  ·   ·  Flag as inappropriate

        Just noticed that you can right click on your 'Date' field and click 'Ungroup' then the issue goes away!

      • Anonymous commented  ·   ·  Flag as inappropriate

        The ability to group when needed was fine, to have automatically group dates especially when you have no idea what information I may need at the time is stupid. I've spent the last hour trying to get this **** turned off because every auto grouping is NOT what I need. Do you guys at Microsoft ever use your brains at all? Stop opting us in to your stupid ideas.

      • Anonymous commented  ·   ·  Flag as inappropriate

        I have turned off in the Options as suggested, but that is not working. And, I do have have permissions to modify my registry. Having a option to turn on/off is fine, but at least make sure it works. BUG!!!!!

      • anneanne commented  ·   ·  Flag as inappropriate

        This feature is unwarranted, who asked for it! It’s added additional calculations in to the PowerPivot background and I don't want the date grouping it adds in the Pivot table. This feature does not suit the type of reports I run for which I’m required to show a date. I don’t have admin rights to turn this off through regedit and there is no option to disable as suggested through File even though I have Office 365 proplus. This has to be the most frustrating feature I have seen come out of any of the new office release.

      • Anonymous commented  ·   ·  Flag as inappropriate

        HATE this auto time grouping! It takes so much effort (and time) to fix what was not broken!! Frustrating!!

      • Anonymous commented  ·   ·  Flag as inappropriate

        Mine is disabled in the menu, but is still grouping. I've tried the option above and changing my registry and still I can't see my data Please do not predict things that I might like to have, this is so annoying and won't go away.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is the most ridiculous thing I have ever seen. It just does not work with my data. The sooner it goes into the bin for ever the better.

      • Anonymous commented  ·   ·  Flag as inappropriate

        This is a horrible "feature" - I have a pivot with 4 individual dates and now Excel has grouped them so that users have to scroll through hundreds of dates in the filter dropdown to turn off one of them. Fail

      • Anonymous commented  ·   ·  Flag as inappropriate

        I've just spent 3 hours trying to figure out why my pivot graphs date selections weren't working properly. Finally... found out that it's because MS is making "improvements" that i can't "opt-in" for ... a) they're on by default and b) i have to edit my registry? 3:11 AM now... 3 hours... thanks MS, job well done.

      ← Previous 1

      Feedback and Knowledge Base