Pivot Tables

[Guest]

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?

 

[Guest]

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.