Pivot Table Selection

[Sandeep Jangra]

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.

 

[Bill Ridgeway]

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

 

[Roger Govier]

Hi Sandeep

Create a Dynamic Range as the source for your Pivot Table.
Insert>Name>Define>
Name myData
Refers to =INDEX($1:$65536,COUNTA($A:$A),COUNTA($1:$1))

Right click on your PT>Wizard>back>Source =myData>Finish