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

[@HasaanFazal]

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

[@RArcher18]

Power Query - select the option to refresh data upon opening workbook. PivotTables - select "Refresh All"

[@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

[@TulanKumar]

Good one. Straight to the point.

[@hvks2y5]

what if the source is another excel file? would this work?

[@moisestatis5418]

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

[@linzibee40]

perfect - exactly what i needed - thankyou!

[@deprive-999x]

You are great.

[@pongpichairatchadanuwat3663]

Thank you for Solution.

[@JB_Photog]

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

[@zakincc]

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

[@HasaanFazal]

Excel allows sharing data between separate files. But you have to keep the location of file containing underlying data to remain same. Otherwise you will have to update the address every time file changes it's location

[@naseervaattolithazha7032]

please explain how to do

[@naseervaattolithazha7032]

its not working in different workbooks

[@tradinggpassion2377]

What if the source is a WebPage.

[@RArcher18]

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.

[@sharathsekhar7386]

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

[@abuena73]

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

[@hki8514]

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

[@alexrosen8762]

Extremely helpful! Thanks :-)

[@bonishimori6656]

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?

[@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 .

[@marcialfigueroa4346]

Tks.! Hassan. Simple and fast solution.

[@luishaka88]

Hope Power automate make a template soon

[@isaidstream4547]

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

[@cooljoker2027]

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

[@nanyardila4258]

I love you

[@hamzawaheed47]

Excellent!!! Thank you very much Sir

[@daveschellhase1874]

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

[@kevinrieder]

What version of Excel do your coworkers have? PQ doesn't come installed out of the box on older versions, so it's possible your company's help desk may need to install Power Query for each of your coworkers as an add-on. I would also normally suggest to ensure they have permissions, but it's likely if they're able to open the workbook at all, then they'll have permissions to execute queries, too.