Pivot Table - Change SQL Statement Problem

[John Michl]

I've been trying to change the database of a pivot table connection. I've
used some code found in KB article 269619. The code works ok unless the
table is derived from another pivot which is the case for the majority of my
pivot tables. Has any one figured out a work around?

Also, is there a way to determine which pivot table is the original and
which is based on previous tables?

Thanks

- John Michl