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.

Do you have a specific function question?

Post a question in the Excel community forum

Help us improve Excel

Do you have suggestions about how we can improve the next version of Excel? If so, please check out the topics at 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 2016 for Windows

Keyboard shortcuts in Excel 2016 for Mac

Excel functions (alphabetical)

Excel functions (by category)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×