One of the downsides of Excel 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 how to automate refreshing a Pivot Table using a single line of VBA code: ActiveWorkbook.RefreshAll

If you’re a Mac user, please check out the note under the video.

Are you a Mac user? I strongly suggest that you watch this video first:

It’s the one I posted on 13th November 2022: “How to Fix Variable uses an Automation type not supported Error in VBA Editor in Excel for Mac”