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.

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, jj.jigga.jo...@gmail.com 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.

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

<(E-Mail Removed)> wrote in message
news:74adb6a9-93e5-4ca1-9117-(E-Mail Removed)...
> 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.
>

I've also just discovered that you can still use the pivot table
wizard and select other pivot tables for source data. So far, the
only way I know how to pull up the PT wizard is though the Excel 03
ALT-shortcut of Alt+D, P.

On Dec 14, 11:53 am, jj.jigga.jo...@gmail.com wrote:
> I've also just discovered that you can still use the pivot table
> wizard and select other pivot tables for source data. So far, the
> only way I know how to pull up the PT wizard is though the Excel 03
> ALT-shortcut of Alt+D, P.

You can put it in QAT, from the "Commands Not In Ribbon" category.