Forum Discussion
Pivot table won't refresh after Data Refresh
Hi
I have a pivot table based on a data model and when I Data -> Refresh All the data updates but the pivot table doesn't refresh. When I right-click on the Pivot table and press Refresh it also doesn't update the data. Its only when I change a filter and then change it back again that the data refreshes. I am on Office365 v2110 (Build 14527.20234). This has just recently started happening so not sure if there is an update to Excel that has caused this to occur. Any suggestions welcome.Pivot table Refresh, Excel
Cheers, Ruth
10 Replies
I'm having this problem now with Office 365 v2202 (Build 14931.20274). My model ran yesterday, but not today. It seems to be a different problem as my data model is not loading. I will submit a separate question.
We have the same problem. The pivot tables won't refresh after we select "Refresh All". Only after we have made some changes to the filters will the pivot tables update their data. It happens only recently for some of our users using Excel 2016 64 bit. If someone can answer that, it would be highly appreciated.
Yuklanl I have found that changing a filter on the pivot table and then changing it back refreshes the data. Microsoft have advised to load an earlier version of Excel and check if that resolves the issue, then we will know its an issue with the latest update. So doing that today and will post the result.
