Pivot Table Selection
"Sandeep Jangra" wrote in message
...
I made a pivot table after selection of complete data. After that some
more
data added to that database. Anyone suggest me when I click on "refresh
data" pivot table should be updated automatically on updated database.
Yes! But, if you add data to the end of the worksheet it wont be seen by
the Pivot Table. It's easier to insert a line(s) in the body of the
worksheet in which to add data. I presume there is a way to correct the
actual Pivot Table after the event. However, I find it easier to create
lines, cut and paste the additional data.
Bill Ridgeway
|