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.

​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.  Read More

​