Pivot Table Selection
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.
|