Check out this link. It should give you a start...
http://www.contextures.com/xlPivot01.html
--
HTH...

Jim Thomlinson


"dat" wrote:

I would like to know how I can update (not Refresh) the pivot table once I
have appended data to my source data. Also, how can you find the source data
that orginated the pivot table. Thanks.
--
dat