Pivot Table Range

[Ian Tranter]

I have a pivot table that sums about 50 rows of data.
How do i get the pivot table to include two new rows of
data that i have added.

 

[Frank Kabel]

Hi
see the following site for creating a pivot table with a
dynamic data range:
http://www.contextures.com/xlPivot01.html