Pivot Tables: Automatically Update When Source Data Changes

Published: 10 September 2018
on channel: Excel Campus - Jon

421,824

3.4k

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...

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.

Download the Excel workbook that contains the code: https://www.excelcampus.com/vba/refre...

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:

VBA Code Modules & How to Run Event Macros Based on User Actions: • How To Create Vba Code Modules In Excel

3-part Video Series on Getting Started with Macros & VBA: http://www.excelcampus.com/vba-traini...

3-part Video Series on Pivot Tables & Dashboards: • Introduction to Pivot Tables, Charts,...

Refresh Power Query Queries Before Pivot Tables (disable background refresh): https://www.excelcampus.com/library/e...
00:00 Introduction
00:55 Adding the Macro
05:00 Other Options

On this page of the site you can watch the video online Pivot Tables: Automatically Update When Source Data Changes with a duration of hours minute second in good quality, which was uploaded by the user Excel Campus - Jon 10 September 2018, share the link with friends and acquaintances, this video has already been watched 421,824 times on youtube and it was liked by 3.4 thousand viewers. Enjoy your viewing!

3,189