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.
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
- Reselecting data ranges for a pivot can be an easy step to forget
- Selecting entire rows of data to be included in a Pivot Table data range will only require a refresh when adding on new data
- A PivotChart can also see the benefits of this step