I'm not sure you understood my question. I want to copy what's in the pivot
to a new worksheet and lose all of the precedents/dependents. How do I do
that programmatically?

"JLGWhiz" wrote:

Hi Barb, I don't use Pivots as a rule but it seems to me that when you set it
up, it creates a lot of precedents and dependents that are all tied to the
sheet. So I would imagine that might be why they are all destroyed when you
copy to a new sheet. Just makes a clean copy without the link complications.
Of course, this is a guess.

"Barb Reinhardt" wrote:

I have a pivot table on a worksheet I'm calling myWS. I'd like to copy the
used range of this worksheet to another worksheet I'm calling ResWS, but lose
the pivot. How would I do that programmatically?

Thanks,
Barb Reinhardt