Pivot Tables - Extend pivot range with new data added at end

Hi - I'm experimenting now and may find the answer, but wanted to quickly ask the experts here.

If a pivot table view was built from 80 rows of data and then 20 new rows are added to the end of the table, how do extend the pivot range to now include 100 cells instead of 80. I've figured out how to refresh counts and totals overwise and any info on adjusting the range would be appreciated.

Thanks, Harry

This definitely wasn't as intuitive as I thought -- but after googling I quickly found the answer on one of my favorite resources -outside of these forums of course

http://www.contextures.com/xlfaqPivot.html

I added new rows/columns to the pivot table source data, and they don't appear when I refresh the pivot table.

If the new fields are outside the pivot table's data range, they won't show up in the field list. To adjust the range:

1. Right-click a cell in the pivot table
2. Choose PivotTable Wizard
3. Click the Back button, and select the new range
4. Click Finish.

Or use a dynamic range as the pivot table source, and it will adjust automatically. There are instructions here:
http://www.contextures.com/xlPivot01.html