I've stumbled along with some VBA programming that allows me to change the
connection and sql properties of a pivot cache. Unfortunately, I've learned
that it is difficult (or perhaps impossible) to change the SQL statement for
a pivotcache that is linked to more than one pivot table. In my workbook, I
have a dozen or so pivottables most of which were created by either copying
the first table or creating a new table that used the first table as the
data source.

1) Does anyone know of a work around that would allow me to change the SQL
properties of these linked tables? (I've got the code working fine for a
single table but not tables based on one central source.)

2) Is there away to determine which table is the initial table from which
the others are derived? When I look at the connection properties they all
seem to look like they connect to the SQL database not to a pivot table.

Thanks.



P.S. I've left a number of messages regarding similar topics over the past
week with no response. Sorry for being a pest but I'm in a world of hurt.

- John