Excel - How to Refresh a Pivot Table Automatically (Windows and Mac)

One of the downsides of Pivot Tables is that they don’t automatically update when the source data changes. You have to remember to refresh them and if you forget, that could lead to misinformation and incorrect decision making.

In this video, I’ll show you, in both Excel for Mac and Excel for Windows, how to automate refreshing a Pivot Table using a single line of VBA code.

🗒 Notes and Resources

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#excel #pivottable #vba

[rstevenhanson]

Bro, excellent job. Went through several other vids that didn't do as quick or thorough of a job. Thank you!

[gsgrady]

Very succint, interesting, and most importantly, useful. Thanks Mike!

[kroyle]

Thank Mike, excellent and very helpful video.

[allenripperden]

Thanks Mike for this video. Well done.

[Ohhkaleyeahh]

Hello, does this refresh in the background without having to open the file?

[michaelgrammo]

Thanks Mike - how do you make the auto refresh occur without needing to switch worksheets?

[stefankleinhans]

Good Day, after saving my excel workbook and exiting, upon reopening the document the macro is gone. is there a permanent solution to keep it there always

[catalinalemus]

Hi Mike. One question, does the pivot table have to be on another sheet?