Excel 2007 - One pivot table; multiple sheets

[Danielle]

All -

I have a workbook with 5 sheets. All sheets a different number of rows
and all have at least 40K rows. I have two columns for which I'm
creating a pivot table. I've been able to do that for one sheet.

What I really would like to do is create one pivot table encompassing
the same columns from the 5 individual sheets. If I could really have
what I want, I'd be able to filter the pivot table so that the data
for each sheet shows individually as as well.

I know that in 2007 I could simply move all the data to one sheet; the
issue is that the person I'm working with has 2003 which has the 65K
row limit.

Any tips, links etc...?

Thanks in advance-
Danielle

 

[Debra Dalgleish]

You can create a pivot table from Multiple Consolidation Ranges in Excel
2007.
To open the old PivotTable Wizard, press Alt+D, and then type P
Then, follow the instructions here, to create the pivot table:

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

 

[Danielle]

Perfect! It took me a few tries to get the hang of it, but the results
are exactly what I want. Thanks for taking the time to respond.

Danielle