"NormDeStorm" wrote:

You have to put a formula like the one below in your data sheet and you give a name to the formula. To do so you go to Menu Insert _ Name_Define.
Add the formula .

=OFFSET('Datas O & C'!$A$1,0,0,COUNTA('Datas O & C'!$A:$A),COUNTA('Datas O &
C'!$1:$1)). Ounce this is done you go to your pivot table and replace the range with the name you give to the formula created.

P.S. 'Datas O & C' is the name of your data sheet.

"Bendinblues" wrote:

The Data that I use for my pivot table keep changing each week. Weekly, I
copy and paste data from another excel spreadsheet into the workbook that
contains the pivot table. Each week I go in and rename the data range before
I refresh the data. Is there a way that I can perform the data refresh on the
new data without worrying whether this week the data contains 25 rows or 50
rows?