Pivot Tables: Automatically Update When Source Data Changes

In this video I explain how to refresh pivot tables automatically when the source data changes. This solution uses a simple VBA macro and the Worksheet Change event.

The Worksheet Change event macro runs every time a change is made to a worksheet. We can use this macro on the sheet that contains the source data to make sure our pivot tables are refreshed whenever the source data is modified or updated.

I also share an alternative to the macro. We can enable the Pivot Table option: "Refresh data when opening the file"

That option will only refresh the pivot tables when the file is opened by the user. It will NOT refresh the pivot tables when changes are made to the source data. For that to happen we need to use the macro solution.

Related videos & articles:

00:00 Introduction
00:55 Adding the Macro
05:00 Other Options

[sstelevision]

If you only knew how long I've been looking for someone to explain this correctly lol. Literally took like 1 minute. Thank you!

[jsingle]

Jon, Thank you SO very much for posting this video! This was the perfect solution to a complex workbook I'm setting up to track a large amount of data in a case where people will updating the source data a lot. Can't thank you enough! :)

[deanzipperer]

Thank you so much for this.. i learned VBA on the fly and never learned some of these little things like the drop downs in the beginning... this was an awesome thing to learn... thank you so much for taking the time to put this video together.. helped me learn something that i most certainly use on a day to day basis.

[ZacCoventry]

This is a well produced and helpful video. Thank you, Jon!

[mofo]

Thank you so much! So simple and yet and I spent so much time looking for this solution, you've brightened my day :)

[BigShlarb]

Nice!!! My first time using code and implementing a VB macro. Thanks to your video, I was able to successfully add this feature to my workbook.

[jenniferbeaulieu]

Thank you Jon, you explain things so well. I had been searching for an answer on auto refreshing queries.

[Qomri]

You're the guy Jon when it comes to VBA tips & tricks; hands down. Always right to the point - THANK YOU.

[jackfirst]

I love this vba macro. the most basic and simplest way for my need now. Thank You

[sdvirk]

Well explained and useful too. Solves the purpose. Thanks.

[rushikeshambulgekar]

This Saved my probably 2 hours of work - Very simple trick

[johnborg]

Thanks Jon. That was very Helpful since I do not know any VBA. So this is very helpful for my users. :)

[ankitrai]

hey Jon, thanks for putting this video, its really very helpful..


thanks Man

[wayneedmondson]

Hi Jon.. nice tip on refresh.. will come in handy for certain applications. Thanks again and Thumbs up!

[arturgarncarz]

Thanks so much!!!! Game changer ;) Regards from Poland

[yeahhhhh]

The best video and explanation on youtube.. it worked great and right away.. Thankss

[leticiaramirez]

Loved, great teacher, thank you so mucho

[scottydo]

Great teaching voice. You're right to the point and easy to follow along! Cheers, Scotty

[sulaimanal-busaidi]

Thank you sir for making our life easier

[carolinademontmollin]

Much appreciated! Fit for a total beginner in Macros