Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
more than 65536 rows | Excel Discussion (Misc queries) | |||
How to put in over 65536 rows? | Excel Discussion (Misc queries) | |||
Add more than 65536 rows? | Excel Worksheet Functions | |||
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
increasing the number of rows of a worksheet beyond 65536? | Excel Discussion (Misc queries) |