ExcelBanter - Pivot Table Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Table Range (https://www.excelbanter.com/excel-worksheet-functions/159856-pivot-table-range.html)

Scott R

Pivot Table Range

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.

Scott R

Pivot Table Range

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.

All times are GMT +1. The time now is 04:30 AM.