Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Building pivot tables in Excel 2007 based on existing pivot tables?

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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 229
Default Building pivot tables in Excel 2007 based on existing pivottables?

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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default Building pivot tables in Excel 2007 based on existing pivot tables?

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Building pivot tables in Excel 2007 based on existing pivottables?

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.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 229
Default Building pivot tables in Excel 2007 based on existing pivottables?

On Dec 14, 11:53 am, 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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show Pages for Excel 2007 Pivot Tables Jim Georgia Excel Discussion (Misc queries) 5 November 11th 09 04:25 AM
Excel 2007 Pivot tables Old Keith Excel Worksheet Functions 3 August 5th 07 02:28 AM
Bug with pivot tables corrupting in Excel 2007 Mike Croom Excel Discussion (Misc queries) 1 May 10th 07 09:02 AM
Excel 2007 Error Reopening Pivot tables Mike L Setting up and Configuration of Excel 6 November 24th 06 10:53 PM
Importing Data into Existing Pivot Tables ? jman559 Excel Discussion (Misc queries) 0 December 7th 05 08:05 PM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"