Nov 07 2021 02:23 PM
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
Nov 09 2021 04:39 PM
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.
Nov 10 2021 11:16 AM
@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.
Nov 11 2021 12:36 PM - edited Nov 11 2021 12:38 PM
We have tracked the last build where this was working is September 14 Version 2108 (Build 14326.20404).
Nov 11 2021 12:44 PM
@RuthS1968 Our IT guy said he found an error on the set up of our reporting server that might have caused the problem for some of our users. Seems the affected users can refresh ok now since last night's fix. We haven't rolled back our Excel upgrade for testing. We are at version 2110 build 14527.20234
Nov 11 2021 12:54 PM
Nov 11 2021 12:58 PM
Nov 11 2021 01:23 PM
Nov 11 2021 01:49 PM
Dec 13 2021 12:37 PM - edited Dec 13 2021 01:46 PM
We tested the latest release of Microsoft 365 – Version 2111 (Build 14701.20226) and the issue is now resolved.
Apr 20 2022 02:38 PM - edited Apr 20 2022 05:33 PM
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.