Forum Discussion

RuthS1968's avatar
RuthS1968
Copper Contributor
Nov 07, 2021

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...
excel
office 365
Yuklanl's avatar
Yuklanl
Copper Contributor
Nov 10, 2021

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.

  • RuthS1968's avatar
    RuthS1968
    Copper Contributor
    Nov 10, 2021

    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.

    • RuthS1968's avatar
      RuthS1968
      Copper Contributor
      Nov 11, 2021

      Yuklanl

      We have tracked the last build where this was working is September 14 Version 2108 (Build 14326.20404).

      • Yuklanl's avatar
        Yuklanl
        Copper Contributor
        Nov 11, 2021

        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

Resources