Debra Dalgleish addresses Dynamic Data Sources on her website:
http://www.contextures.com/xlPivot01.html
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"carl" wrote:
I am using the Pivot Table "Refresh" to update the table. However, the table
does not update to reflect the new source data (I paste in the new data -
each time I paste in new data there are more rows). Does the Refresh only
look at the orginal range of data ?
Is there an easy way to have the Pivot Table update as I add more source
data ?
Thank you in advance.