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.