Auto Refresh Excel Pivot Tables + Power Query Connections If Source Data Changes

In this Free Excel Tutorial we are learning a simple line of VBA code that will automatically refresh Pivot Table report and Power Query Connections every time source data changes in Excel worksheet.

Its quite a task if you have refresh pivot tables manually every time after making changes to source data range. But you can automate the whole refresh process by knowing just one line of code in Visual Basic.

!! Get FREE Excel CORE BOOK:

#AutoRefresh #PivotTable #PowerQuery

[HasaanFazal]

How do you go about refreshing Pivot Table Reports and Power Query Connections and Queries? Manual or Automatic?

[mfrancalancia]

What happens if your source data is in another Excel file (a Table in another workbook) and you import this data with Power Query ? Can you still use this code ? Should I modify the VBA code ? How to automatically refresh data when both the source Excel file and the destination workbook are stored in Excel online and data is added in the source through Excel online. Thanks in advance

[marcialfigueroa]

Tks.! Hassan. Simple and fast solution.

[linzibee]

perfect - exactly what i needed - thankyou!

[RArcher]

Thank you for the video. Extremely easy to follow and useful. Is there a VBA that allows the same "auto refresh" when the sheets are protected? In my scenario. Both the Source Data Table and PivotTable(s) reside in different worksheets in the same workbook. PivotTables are linked to charts in other protected sheets in the same workbook. The entire workbook is protected but specific cells in the other worksheets are unprotected to allow other users to enter data. I've found some answers online that indicate it is possible but the VBA does not fit our scenario. I'm hoping you can help.

[moisestatis]

Great simple solution, thanks. Would the same code work for an Excel file online (Excel web)?

[JB_Photog]

For multiple tabs/connections/pivots do you have to have vba for each sheet?

[abuena]

you retain your file as xlsx instead of xlsm..? will it really work under xlsx file type since putting that vba script must be treated as a macro-enabled worksheet already

[hki]

Just having a hard time getting multiple sheets to do this to one pivot table that is appended using power query

[samarmandke]

HI I am trying to use this . But my Power Query is refreshed but my pivot table needs to refresh manually . Can u tell me what is gng wrong .

[isaidstream]

Hello. The problem is my Power Query Connected to a CSV file (that is constantly changing) :/. I need realtime, thanks.

[zakincc]

Thanks for this video. What if, my base data is in a different file and table and pivot is in a different file?

[sharathsekhar]

How do you refresh pivot table automatically if the data source is from power bi??Can we use the same VBA or anything new to be added.please help me

[bonishimori]

Hi. I am trying to run my Excel file saved in my OneDrive which is synced to my desktop.
vbs unknown runtime error 800a03ec. would you know how to fix this?

[luishaka]

Hope Power automate make a template soon

[daveschellhase]

Anyone know why my coworkers are unable to refresh my queries? File lives on a shared onedrive.

[cooljoker]

i have the fuuuking problem in the data table when i write new data doent take it as part of the table

[spyxxx]

how do I make it refresh daily once a day to feel into a report?