If you have added data to the bottom of the range used for the pivot table,
then note the address of last cell of the range, often the column will be
the same, just the row number will be increased.
Then click on the pivot table anywhere, click on Data, Pivot table & pivot
chart report.
In the box which appears click on back
Amend the range (often just the row number will have to be edited)
Then click on finish.

I hope that is what you wanted,
Barbara

"derwood" wrote in message
...
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