How to change Pivot Range dynamically(Macro)

[leninbabu]

Hi,
I have created a Pivot Table using Macro. In that ROWS or COLUMNS appended to the existing table are not reflecting when I am running macro.
Pl help..

Pl read Title as "How to change..."

[DonkeyOte]

I would suggest you create a Dynamic Named Range as source for PT - as you add/contract the source data so the named range and in turn the PT range will update accordingly.

For more info. on creating Dynamic Named Ranges see the link in my sig. to Debra Dalgleish's excellent Contextures site.