Excel 2016 - 3.1.10 - Refresh the Data

This video shows you that if you increase your original dataset you then need to Refresh the PivotTable so that it picks up the new data. If your original dataset was turned into a Table before being made into a PivotTable we’ll see that the Refresh is very simple. However, if the dataset was not turned into a Table first, then there is a little more work involved in Refreshing the PivotTable.