how can i include new add data on my pivot table

[vicki]

Dear Phillips,

thanks for your quick reponse. But how I can connect this function to the
pivot table? I have followed the step Insert>Name>define and input the said
formula "=offset(data!$A$1,0,0counta(data!$1:$1))" on the data worksheet.

What will be next step I need to do so that the pivot table can be updated
automatically when new rows are added on the data worksheet.


thanks again.

 

[Luke M]

(Assuming you defined your named range as MyRange)
Under you pivot table options, where it has you select a range of cells, type
=MyRange

The Pivot Table now looks to those cells, which based on the OFFSET formula,
will adapt as needed. Again, change "MyRange" to whatever you decided to call
your Range.

 

[vicki]

Luke,

it works now, million thanks for your help.