You don’t have to use workarounds or make changes to the registry. If you’re using Excel 2019 or Excel for Office 365, there’s good news. See the simple steps below.įor Excel 2016, it takes more work - use either the Excel 2016 Workaround, or the Excel 2016 Registry tweak, described below.įurther down in this blog post, you can read more about date grouping in Filters, and the benefit of pivot table date grouping, which started in Excel 2016. It’s easy to prevent automatic date grouping for pivot tables in Excel 2019/365, by changing a setting.
You can also read about why this feature was added, and watch a date grouping video.
See how to stop pivot table date grouping in the latest versions of Excel, and a couple of workarounds for Excel 2016.
When you add a date field to your Pivot Table, Excel automatically groups the dates into a hierarchy, such as years and months.
