Pivot table

[Thyag]

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

 

[Guest]

i have half a solution for you. but not the whole caboodle.

your pivot table is on the same sheet as your data.

if you make your data a named range (insert>name>define)
and then set up your pivot table source to be this named range, when you
copy a sheet you will find that the named range has copied too.

depending on which sheet you are on, the named range applies to that sheet

so if you change a value in one sheet, and refresh the pt from that sheet,
it will find the new data

sadly the pt on the orignal sheet changes at the same time.

interesting. i only have ten minutes and couldn't get to the end o fthis