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.

Selecting entire columns of data for a Microsoft Excel PivotTable.

Now when updating your workbook and dropping in new data the only other step will be to refresh the PivotTable.

Click here to learn how to make a PivotChart that will update along with a Pivot Table.

summary