D
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
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