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".
When asked if you’d like the Registry Editor to make changes to your computer, click yes.
On the left hand side of the new Registry Editor window that opens, select HKEY_CURRENT_USER.
In the menu beneath that, select SOFTWARE > Microsoft > Office > 16.0 > Excel > Options.
Next, select Edit > New > DWORD (32-bit) Value, and rename the new DWORD value to "DateAutoGroupingDisabled".
Press enter to edit the new DWORD value, and set its Value data field to “1”.
Note: The new key is effective immediately, there is no need to restart Excel.
Do you have a specific function question?
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