Pivot Table Selection

  • Thread starter Thread starter Sandeep Jangra
  • Start date Start date
S

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.
 
Sandeep Jangra said:
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.
Click to expand...

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
 
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
 
Back
Top