#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephanie Lampert
 
Posts: n/a
Default Pivot Tables

Is it possible to create a pivot table extracting data from 3 separate tabs
in 1 .xls (auto calculated) without created a fourth tab (for totals) and
building the pivot table from that?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default Pivot Tables

The pivot tables have an option for Multiple Consolidation Ranges, but it is
not the same as the usual pivot table, as here you can only play with "row",
"column", "value" and "page", that normally is not what you would expect.
So the short answer is No, you need to consolidate the data to create a
pivot table.

Miguel.

"Stephanie Lampert" wrote:

Is it possible to create a pivot table extracting data from 3 separate tabs
in 1 .xls (auto calculated) without created a fourth tab (for totals) and
building the pivot table from that?

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
Refreshing Pivot Tables linked to Oracle Datasource [email protected] Excel Discussion (Misc queries) 0 April 25th 06 12:15 AM
Multiple Pivot tables from One selection dapo Excel Discussion (Misc queries) 2 December 29th 05 04:02 PM
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 04:50 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 02:03 AM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 02:34 AM


All times are GMT +1. The time now is 10:45 PM.

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"