Consolidate data from worksheet (more then 65536 rows)
 

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

Consolidate data from worksheet (more then 65536 rows)
 

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

--

Regards
Roger Govier

"Mandeep Dhami" wrote in message
...
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