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