Updating excel from vb
If this is the case, it’s likely that you haven’t saved the file as a macro-enabled workbook (.xlsm), and/or enabled macros.
Checkout my article on VBA Code Modules & How to Run Macros Based on User Events to learn more about the sheet modules and events.
Bottom Line: Learn how to use a simple macro to refresh pivot tables automatically whenever changes are made to the source data.
I also share a non-macro solution to update the pivot tables when the file is opened. Skill Level: Intermediate If you learn best by doing it on your own, you can download the file I'm using in the video to follow along. Refresh Pivot Table (41.5 KB)Can your pivot tables be updated immediately and automatically when their source data changes? It requires the use of a really simple macro that I will show you how to create below.
To do so, choose Worksheet in the Object drop-down box on the left.
That will add a Worksheet_Selection Change event to the module, which we don’t actually want, so we will delete it in just a moment.