Forum Discussion

Mariham Iskandar's avatar
Mariham Iskandar
Copper Contributor
Aug 25, 2017
Solved

Pivot Table Will Not Update Properly

I have data created in PowerQuery that is connected to PowerPivot which generates PivotTable in my excel sheets. I have noticed that my pivot tables do not refresh with the most recent data once I: r...
BI & Data Analysis
excel
Macros and VBA
office 365
  • Vinod Jagroep's avatar
    Vinod Jagroep
    Jun 06, 2018

    I always had the exact same problem and finally found the solution, which appears to be embarrasingly simple.

    Click Change Data Source. After updating my data (obviously) the data range has expanded! Select the data set again and voilà.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 25, 2017

Hi Mariham,

 

Check your query properties and be sure what "Enable background refresh" in your main queries properties is unchecked. With background refresh disabled the query complete refresh before other queries are refreshed and as well before pivot tables are refreshed.

 
Mariham Iskandar's avatar
Mariham Iskandar
Copper Contributor
Aug 25, 2017

Thanks for the quick reply! I really appreciate it!  Could you possibly walk through how to check my queries properties?

  • Mariham Iskandar's avatar
    Mariham Iskandar
    Copper Contributor
    Aug 25, 2017

    Figured out how to check query properties and the "Enable background refresh" tab is unchecked already. This did not make a change.

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Aug 25, 2017

      Hi Mariham,

       

      Let me clarify

      1) With Refresh All not all PivotTable are refreshed. If you click RefreshAll once more (without changing any data) does that refreshes PivotTable?

       

      2) You disable "Enable background chacking" only for queries which upload data from external sources into data model or for all queries?

       

Resources