how can i include new add data on my pivot table

[vicki]

Happy New Year and all the best.

I have a pivot table which looks up a worksheet data who's range change
daily, i.e. new data are added every day. Is there a way to have the pivot
table select all rows of data without having to change the data range
manually everyday?

many thanks.

 

[Bob Phillips]

Define a dynamic named range for the data and use that in the pivot table.
See http://www.contextures.com/xlNames01.html#Dynamic

 

[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.

 

[Bob Phillips]

vicki,

You then use that defined name in the pivot table source data.

 

[vicki]

Dear Bob,

it works now, many thanks for your help.