Pivot Table Refresh

Copper Contributor

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 year analysis limit but retrieving an older back up the same thing happens. I am now wondering if the Pivot Table program has been updated? When I look at the Field List the Months and Years fields no longer show. Any help would be appreciated.

1 Reply

@brownt53 

As variant you need to group dates from right click menu

image.png

Plus check if in Excel Options automating grouping is not disabled

image.png

 

Another variant if you eventually added to the source text which looks like date (actually dates are numbers), when grouping doesn't work

image.png