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