Turn off time grouping in PivotTables in Excel 2016 for Windows

Warning: This article describes how to make changes to the Windows Registry. Incorrectly editing the registry may severely damage your operating system, requiring you to reinstall it. Microsoft cannot guarantee that problems resulting from editing the registry incorrectly can be resolved. Before editing the registry, back up any valuable data. Use Registry Editor at your own risk. For the most recent information about using and protecting your computer's registry, see Microsoft Windows Help.

To turn off time grouping on PivotTables (including data model PivotTables) and Pivot Charts, follow these instructions for adding a new DWORD (32-bit) Value registry key. The new key is: HKEY_CURRENT_USER > Software > Microsoft > Office > 16.0 > Excel > Options > DateAutoGroupingDisabled.

  • Click the Windows Start Menu and type "regedit.exe".

    Windows Start menu - Regedit.exe
  • When asked if you’d like the Registry Editor to make changes to your computer, click yes.

    User Account Control request to execute Regedit.exe
  • On the left hand side of the new Registry Editor window that opens, select HKEY_CURRENT_USER.

    Regedit dialog - HKEY_CURRENT_USER > Microsoft > Office > Excel
  • In the menu beneath that, select SOFTWARE > Microsoft > Office > 16.0 > Excel > Options.

    Regedit > Name new DWORD value > DateAutoGroupingDisabled
  • Next, select Edit > New > DWORD (32-bit) Value, and rename the new DWORD value to "DateAutoGroupingDisabled".

    Regedit > Edit > New > DWORD (32-bit) value


    Regedit > Name new DWORD value > DateAutoGroupingDisabled
  • Press enter to edit the new DWORD value, and set its Value data field to “1”.

Regedit > DWORD > Change Value data to 1 from 0

Note: The new key is effective immediately, there is no need to restart Excel.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Overview of formulas in Excel

How to avoid broken formulas

Use error checking to detect errors in formulas

Keyboard shortcuts in Excel for Windows

Keyboard shortcuts in Excel for Mac

Excel functions (alphabetical)

Excel functions (by category)

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×