Perhaps you can use a dynamic range as the source:

http://www.contextures.com/xlPivot01.html

Then if you add new data, it will be automatically detected when you
refresh the pivot table.

Daniel wrote:
Thanks KG
Why I hit refresh data at pivot table and new data in the field not enter
pivot table?
How do I know my data range beyond the range in data field?
What shoud I do to choose a wide range in data field so I can use
refresh data at pivot table?
Thnks
Daniel

"kg" wrote:


Refresh will work unless your data field has grown beyond the data range
specified in your pivot table.
"Daniel" wrote:


If my data in the field is growing, can I hit "refresh data" so new data will
be entered in my pivot table ? Or I have to make new pivot table ?
If I have to make new table again so what is the meaning of refresh data ?
Thanks for your help
Daniel



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html