+ Reply to Thread
Results 1 to 2 of 2

Pivot table Group feature not turning off

  1. #1
    Registered User
    Join Date
    12-24-2006
    Posts
    32

    Pivot table Group feature not turning off

    Hi All,
    I used the excel Pivot table group feather for doing a fiscal year report, Now when I create a pivot table this feature is automatically created. How do I turn this off. I have check off the upgroup and it display the dates again, However when i create a Pivot table with dates. it again sets it up with fiscal and year. I can't keep ungroup the date field. Any thought and/or assistance appreciated.
    James

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Pivot table Group feature not turning off

    Vandering thru...

    try this way:
    1. regedit
    2. HKEY_CURRENT_USER
    3. SOFTWARE > Microsoft > Office > 16.0 > Excel > Options (you need to check your version)
    4. DateAutoGroupingDisabled - set to 1 (if you want it back - set to 0)

+ 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. Pivot Table Variable Not Turning On
    By rbirch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2015, 09:55 AM
  2. Use more than one summarize feature in pivot table
    By M_DACH in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-31-2014, 06:49 AM
  3. Turning off Excel feature.
    By WillFahmy in forum Excel General
    Replies: 2
    Last Post: 02-22-2013, 04:05 PM
  4. Pivot Table turning out oddly
    By edtabakman in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-20-2012, 07:22 PM
  5. Turning Off Pivot Table Refresh
    By Dendrinos2 in forum Excel General
    Replies: 0
    Last Post: 11-14-2011, 09:35 AM
  6. Turning Ink Feature On or Off
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-19-2011, 07:37 PM
  7. using the pivot table feature can anyone help
    By max in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-19-2006, 06:20 AM

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