Learn about a new Pivot Table feature that has taken Microsoft 35 years to develop and release, but it is FINALLY here. Auto refresh of Pivot Tables when the underlying data changes. HOORAY!!!!!!!
File Download Link:
https://www.bcti.com//wp-content/YT_Downloads/BCTI_PT_AutoRefresh.zip
00:47 Introduction to Pivot Caches
01:31 Older ways to automate data refreshes
01:46 Creating a pivot table
02:05 Manual refreshing of the data
03:22 Feature availability
03:38 Turning the feature off and on
04:21 Alternate method of turning the feature
04:37 Turning the feature off and on at a program level
05:24 Updating all connected Pivot Tables
