pivot table

[bvbvince]

Hello,
I've a pivottable which is based on many Exel-Sheets. Therefor I've se
the pivot with 4 individual sidefields, but it is not possible for me t
select the contents of these fields. Can somebody help me ??

greetings,
bvbvinc

 

[Debra Dalgleish]

You can create a Pivot Table from multiple consolidation ranges, but you
won't get the same pivot table layout that you'd get from a single
range. There's an example here:

http://www.contextures.com/xlPivot08.html

If possible, store your data in a database, or on one worksheet, and
you'll have more flexibility in creating the pivot table.