ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Basing a Pivot Table on Another Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/119288-basing-pivot-table-another-pivot-table.html)

Ken

Basing a Pivot Table on Another Pivot Table
 
In Excel 2003, I was able to use another Pivot Table in the Worksheet as a
Data Source. In Excel 2007 I can't figure out how to do it.

Any ideas?

Debra Dalgleish

Basing a Pivot Table on Another Pivot Table
 
You can use the same data range that an existing pivot table is based
on, or copy and paste an existing pivot table.

Ken wrote:
In Excel 2003, I was able to use another Pivot Table in the Worksheet as a
Data Source. In Excel 2007 I can't figure out how to do it.

Any ideas?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com