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à.

Sawcy1's avatar
Sawcy1
Copper Contributor
Feb 26, 2021

Hello SergeiBaklan,  I wanted to post some VBA code I use to disable background refresh for all of my connections in case anyone would find it useful.  I run this code on a regular basis as Excel seems to change this every time I decide to touch a query ☺  When you have many queries, this sure does come in handy!

 

Sawcy1

Yemisi13's avatar
Yemisi13
Copper Contributor
Mar 15, 2021

HSawcy1  I have same issue, Refresh All is not refreshing my the data source in my power query which is connected to my pivot table in excel.

I followed the same steps you provided which is to uncheck the box enable background refresh but it did not help.

Do you know any further steps I can take to solve this please?

Resources