Hi Kenneth

There doesn't seem to be the option for Multiple Consolidation ranges in
XL2007.
However, if whilst in a cell within any of your source table, you type
Alt+D+P it will invoke the old PT wizard and you can select your ranges
from there.

--
Regards

Roger Govier


"Kenneth Andersen" wrote in
message ...
Hi

I would like to make a pivot table in a file, where the data area is
in 15
other sheets in the workbook.

The problem is, that I cannot find the function in Excel 2007, maybe
because
I have just got the new version of Excel yesterday, and haven't got
used to
the new look.

In Excel 2003 there was a function during the creation of a pivot
table,
where it was possible to create the pivottable based on multible
areas, but I
don't think it was very usefull, because it wasn't possible to make
the same
build up of the pivottable as in a pivottable based on only one data
area.

I hope some of you out there can help me solving my problem.

Kind regards
Kenneth Andersen