Pivot Table Data Dource Question

J

JWNJ

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.
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date/Time issue with Pivot Table 3
Pivot Tables in 2007 1
moving pivot table data source files 2
Pivot Table Refresh not working properly 1
Getting source data range in multiple pivot tables 1
Pivot Table Data Source 1
How can I change the source data reference to another pivot table? 2
re-using pivot table layout 1

Top