In the example if you add a row to the bottom of the sales table or change any of the data in the table, then select anywhere in the pivot table and click Data -> Refresh.
You can automate the refreshing of the pivot table using VBA if you wish, so any change to your data is immediately reflected in the pivot table.
Bookmarks