Pivot Table Refresh
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.
"carl" wrote in message
...
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.
|