Consolidate data from worksheet (more then 65536 rows)

M

Mandeep Dhami

Hi,

Is it possible in Excel to combine data in one worksheet with rows more then
65536.

I get some data from an ERP application that has data more then 65536 rows,
the application automatically divided that report into multiple worksheets in
same file.

To work on it I need prepare several pivot tables and add data manually.

I would like to know if following is possible:

1) Consolidate data from multiple worksheet into one worksheet (approx. data
rows that I have is 130,000 to 160,000)

2) If request one is not possible then can we create a single pivot table
where data can be picked from multiple worksheets.

Cheers,
Mandeep
 
R

Roger Govier

Hi

Unless you use XL2007, you cannot exceed 65536 rows. XL2007 allows just over
1 million rows.

You can use data from Multiple Consolidation ranges when creating a Pivot
Table, but the results will not appear the same as as when using a single
source.
Look here for more information
http://www.contextures.com/xlPivot08.html
 

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

Data consolidation 0
consolidate data in pivot table 1
consolidate workbooks to worksheets in one workbook? 1
Consolidate tables/ranges with text from multiple worksheets 1
Merge 2 datasheets into single Pivot Table. 0
consolidate multiple worksheets 13
Consolidate Pivot Tables/Cache using Excel 2003 1
Combining data from multiple worksheets into one 4

Top