<b>Pivot Tip 20</b> - Change the Range name to A:K if you intend to add more records
ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables. To test these tips for yourself, try them out on your copy of the pivot_practice.xls database.
Suppose that you have created a pivot table report which you intend to update regularly each week or month. Before running it each time, you will be adding some new records to the database.
Every time you add new records you will have to manually change the data range.