Pivot Table Playground #3 - Automatically update pivot table when source data changes
Channel: Kunaal Naik | Data Science Masterminds
Date: 27/05/2020

Pivot tables are wonderful for creating summaries. However, they struggle to update source data automatically. But there is a simple fix for the same. You can provide a name to the Tables using Format as Table. This way the Pivot tables automatically refreshes with new data as the named table takes care of the same. 

#pivottables #excel