Forum Discussion
Pivot Table Refresh
I created a Pivot Table on 26/5/2020 and it worked well until 25/5/24. It analysed Row Labels in Year, Month, Date. Now when I refresh it only shows the date. Initially I thought maybe there is a 4 y...
As variant you need to group dates from right click menu
Plus check if in Excel Options automating grouping is not disabled
Another variant if you eventually added to the source text which looks like date (actually dates are numbers), when grouping doesn't work