Hi

The default in XL2007 is to use the same data for all PT's created, unless
you override the the source data.

--

Regards
Roger Govier

wrote in message
...
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.