Tuesday, January 08, 2019

Turn off time grouping in PivotTables in Excel for Windows

https://support.office.com/en-us/article/turn-off-time-grouping-in-pivottables-in-excel-for-windows-6be5afed-348c-4db2-9f87-5ac262d67b3f?ui=en-US&rs=en-US&ad=US

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.