Oct 23 2019 04:30 PM
I have a Pivot Table which is grouped by Year. When I add new records to data source, then hit refresh in Pivot Table, the grouping defaults to Month. I would like it to remain by Year.
I tried the 'Disable automatic grouping of Date/Time columns in PivotTables' but that did not work.
Any suggestions?
Thank you,
Oct 23 2019 05:30 PM
Odd, it should be fine. Can you add a screenshot of your Group By box and the Pivot Table fields
Oct 23 2019 06:02 PM
SolutionHi
There is also a possibility that you created another Pivot Table using the same Cache memory with a different grouping. In such case, excel attempts to save memory and it uses the same Pivot Cache and accordingly messes up the first Pivot with a different grouping.
if so, the problem can be fixed by using a FRESH copy of the pivot cache. I explain that in this tutorial:
https://www.youtube.com/watch?v=qebR0Bfe-9g
Hope that helps
Nabil Mourad
Oct 23 2019 11:34 PM
Oct 23 2019 06:02 PM
SolutionHi
There is also a possibility that you created another Pivot Table using the same Cache memory with a different grouping. In such case, excel attempts to save memory and it uses the same Pivot Cache and accordingly messes up the first Pivot with a different grouping.
if so, the problem can be fixed by using a FRESH copy of the pivot cache. I explain that in this tutorial:
https://www.youtube.com/watch?v=qebR0Bfe-9g
Hope that helps
Nabil Mourad