I did some testing on this, and it appears as though Excel 2007 does
this by default. If you create multiple pivot tables from the same
data, then use this line of code in the debug window:

Debug.Print ActiveSheet.PivotTables(1).PivotCache.Index

returns the same index for all tables created from the same source
range.

On Dec 13, 3:27 pm, wrote:
So I just installed Excel 2007, and other than the initial shock of
interface change, its seems pretty good. I like that the prior Office
keyboard shortcuts still work.

I've been going though some of the Excel features/commands I commonly
use and I haven't been able to figure out how to build a pivot table
based on an existing pivot data. This was something that I ALWAYS
used in previous versions of Excel, it kept the file size manageable
and tables refreshed throughout tabs, but it looks like its no longer
possible now that they've changed the way pivots are created.

Please tell me that I am missing something.