Its all good, it was quite simple i just read it wrong, sorry guys

"Scott R" wrote:

This is the same question as someone posted on 08/0/07 however I dont
understand the answer.
I have a pivot table reading data from a worksheet which continually grows.
I would like to refresh the pivot without having to go into the data and
change the range each time. Does anyone know a way for this to happen? any
help would be appreciated.