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" 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

Hi Sandeep

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

Right click on your PTWizardbackSource =myDataFinish

--
Regards
Roger Govier

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