I'm not sure what you want to do. But as an alternative, you may want to record
a macro when you create the pivottable. Then just run the macro when you want
to regenerate the pivottable.

MB wrote:

How do I create my own PivotTable template?

--

Dave Peterson