And instead of a shortcut, you could add the PivotTable Wizard to the
Quick Access Toolbar. In the English version, click the Office button,
then click Excel Options, and click Customize
In the list at the top left choose All Commands
Scroll down to find PivotTable and PivotChart Wizard
Select that command, and click Add, then click OK

Kenneth Andersen wrote:
Hi Roger

Thank you for your answer. I'm using the danish version of Excel 2007, and
the shortcut Alt+D+P doesn't work. Could you please tell me what the menu
Alt+D+P means. It would help me to find out what the danish menu is.

Kind regards

Kenneth Andersen

"Roger Govier" skrev:


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





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