how can i include new add data on my pivot table

  • Thread starter Thread starter vicki
  • Start date Start date
V

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.
 
(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.
 
Back
Top