I have two large spreadsheets in the same file ~ one has the max number of
rows and the other is at 30K rows. The layout of both spreadsheets is the
same. Is it possible to create a single Pivot Table using both spreadsheets
are the data source? I have Excel 2007 if that makes a difference. Thanks
in advance for your help.

Hi,

Do you mean that you have 1,048,576 rows in one sheet and 30,000 in another?
If that is the case you can do it but its rather complicated. Before doing
that, remember that in 2007 you can have 1,048,576 rows on a single sheet.
If you open a 2003 file in 2007 you will see 65,536 rows, but all you need to
do is to save the file as a 2007 XLSX file, close and reopen it.

Then copy the data from the 30,000 rows and paste it below the 65,536 rows
and go from there.

--
Thanks,
Shane Devenshire


"JWNJ" wrote:

I have two large spreadsheets in the same file ~ one has the max number of
rows and the other is at 30K rows. The layout of both spreadsheets is the
same. Is it possible to create a single Pivot Table using both spreadsheets
are the data source? I have Excel 2007 if that makes a difference. Thanks
in advance for your help.