Forum Discussion
Pivot Table Will Not Update Properly
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à.
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.
SergeiBaklan Hi Sergei, my excel has 8 queries (with no errors) and I have unchecked the background refresh. Yet my existing pivot table does not reflect new data completely. I am showing data for 5 years and the data for two latest years is not getting updated. However, if I create a new pivot using the same power query table, the data is accurate. I cannot upload the excel as it is confidential but would be more than happy if you could help find a solution here.