hi
i have pivottables that are referencing data from a worksheet in the same
workbook.

as i am adding data constantly to the worksheet how do i change the data
range in the pivottable so it is reflected when i refresh
thanks