Microsoft Office Excel 2016: Part 4 (Data Analysis with Pivot Tables) - By default, a pivot table will not automatically update itself when the source data changes. Learn how to manually update the data in a pivot table. (Refresh Menu, Change Pivot Table Data Source Dialog Box, Connection Properties Dialog Box)