How to Make a Pivot Table with Increasing Data Ranges
Often Pivot Tables are used for reports that are updated with more and more data week to week and more and more rows. This means that every time the source data is updated, one must ensure all the data is selected for the Pivot and refresh. This extra step costs time and in some cases can cause mistakes.
One way to fix this is to select full columns of data when selecting data ranges. In the example below, we have data in columns A through I. In the create a PivotTable menu, we have selected all data in those columns Sheet1!$A:$I.