Hi friends,

I have a small problem with pivot table -

When ever i create a copy of a sheet containing the pivot, the pivot
range in the new sheet will be for old sheet cells.

is it possible to overcome this, meaning is it possible to make the
range as activesheet name automically.


Thanks
Thyag