Do Pivot Tables have an automatic data range expansion?

[David.c.h]

As I add new rows of data to my data base, my pivot table will not expand to
include them after refreshing. Is there any way of setting the pivot table
to include the entire database regardless of its continuously growing size?
Right now, as I add a new row of data I must delete my old Pivot table and
create a new one from scratch. Is this normal?

 

[Dave Peterson]

You can use a dynamic range that grows/contracts with your data.

Debra Dalgleish explains it all at:
http://www.contextures.com/xlNames01.html#Dynamic