Consolidate data from worksheet (more then 65536 rows)

[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

 

[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