You have to put a formula like the following one. From Menu Define _ Insert _
Name add the formula. P.S. 'Datas O & C' is the name of your data sheet.

=OFFSET('Datas O & C'!$A$1,0,0,COUNTA('Datas O & C'!$A:$A),COUNTA('Datas O &
C'!$1:$1))

"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?