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 do...
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.
We have tracked the last build where this was working is September 14 Version 2108 (Build 14326.20404).
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
- Yuklanl. We are keen to know what fix he applied to the reporting server as we tried on the latest build (version 2110 Build14527.20276 ) and still had issues. Is he able to post on here what he did. Thanking you in advance.
- Our IT guy response: the networking subnet mask on the server was wrong. I’m sure it has nothing to do with the issue they are experiencing in the forum. This was a configuration mishap on my part.
