Thanks Debra,

That would work well when there is only one data source in the
workbook. I have to selectively change each pivot table cache since
my 30+ pivot tables use one of 8 different data tables in the same
workbook.

I can use this method in other workbooks, though. I built several "on
the fly" and am now trying to clean them up.

Thank you,

Don S

On Tue, 22 Mar 2005 15:43:12 -0500, Debra Dalgleish
wrote:

Another option is to change all pivot caches to match that of a
specified pivot table. There's sample code he

http://www.contextures.com/xlPivot11.html

Don S wrote:
When you build pivot tables, you are given the option to share source
data with an existingr pivot table (when applicable).

If this option was not selected when the workbook was developed, is
there a way to get pivot tables using the same data table to share the
cache - short of recreating them?

Thanks!
Don S