Pivot Table Refresh

C

carl

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

Alan

Refreshing the table does not change the range that the table is looking at,
you need to do that manually I think. One way round it, say your range was
A1:J2000,
change this to A:J or A1:J20000 so any more rows you add will be
encompassed. This does have the disadvantage of making the file
significantly larger,
Regards,
Alan.
 
Top