Search code examples
excelvbapowerquerypowerpivotsap-erp

Why pivotTable dont update after using RefreshAll or .PivotCache.Refresh - VBA

In resume, It's an extract from SAP ERP, copy/paste in a table, this table is treated by Power Query and exported to a Pivot Table.

I'm doing a dashboard with VBA + PowerQuery + SAP ERP data, my doubt is in the VBA part, after Copy and Paste information of SAP ERP on Excel, I tried to Running a code ActiveWorkbook.RefreshAll but it's not working, I tried this: Link but it doesn't work too.

I've tried this too: Link and still doesn't work.

The code and the file are in my gitHub Link

Solution

  • Change the Query properties window, you need to uncheck the "Enable background refresh

    Reference: https://www.youtube.com/watch?v=HrR-FwEXjGM