If you work with Pivot Tables and you’re constantly adding new rows of data to the source which means that you’re constantly updating the data source of the pivot tables…this video provides a real time-saving tip

The video is recorded in Excel on the Mac. However the tip can apply to Windows too if you store the source data in the worksheet rather than the data model.