+ Reply to Thread
Results 1 to 4 of 4

Excel 2016 Pivot Issues

  1. #1
    Registered User
    Join Date
    07-27-2016
    Location
    Utah
    MS-Off Ver
    2013 and 2016
    Posts
    5

    Angry Excel 2016 Pivot Issues

    In Excel 2016, pivot tables handle dates and times differently and it's driving me crazy. Every time I pull dates or times into a pivot table, Excel automatically creates new fields that bucket my data. For example, if I try to do a simple count of interactions during 15-minute intervals, it does this:

    Pivot.PNG

    This results in lost data, because it isn't giving me the count for the intervals that fall on hour. With dates it's even worse. It buckets the date into years and months automatically, when all I want is a list of dates and their corresponding count. Does anyone know how to turn this off? I've looked everywhere and I can't find anything about it.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Excel 2016 Pivot Issues

    Right click on the date field in the pivot table and select Field Options. Look at the Group setting.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel 2016 Pivot Issues

    you can press ctl+z to undo the auto grouping or if you really don't like the automatic grouping you can turn it off through the registry- https://support.office.com/en-us/art...rs=en-US&ad=US
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    07-27-2016
    Location
    Utah
    MS-Off Ver
    2013 and 2016
    Posts
    5

    Re: Excel 2016 Pivot Issues

    Awesome, thank you both so much. Your answers were extremely helpful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date Format for Grouped Pivot Table data in Chart - Excel 2016
    By Cam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-15-2016, 03:20 AM
  2. [SOLVED] calculating specific data from a pivot table to create a pivot chart in Excel 2016
    By cinstanl in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-15-2016, 12:14 PM
  3. [SOLVED] Issues with code sent from 2010 to 2016
    By dwr2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2016, 03:57 PM
  4. Excel 2016 issues: Adding sheets and find replace.
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2016, 07:25 AM
  5. Replies: 2
    Last Post: 02-21-2016, 03:33 AM
  6. Excel 2016: Pivot table dates - useless!
    By domgilberto in forum Excel General
    Replies: 1
    Last Post: 02-17-2016, 01:43 PM
  7. Replies: 0
    Last Post: 01-09-2016, 02:02 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1