Can you record a macro while creating the pivot table so we can see what you
are trying to change. I'm not sure where the source of the pivot table is
coming from and the macro will make it easier to write the code.

"Michael" wrote:

Hi,

I need some sample code to change SQL in an existing pivottable named
as Table1. Thanks a lot. Mike.