| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with more than 65000 rows in Excel
Hi am using Excel 2003.
I am in need to work / download data from SAP system into spreadsheet. I need to download about 2 lac rows of data into excel. whereas Excel 2003 allows me upto 65 odd thousand rows only ... How can I download / view this one ?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Working with more than 65000 rows in Excel
If you can get the file in a text/csv file format, you can split the import
across multiple sheets. See www.cpearson.com/Excel/ImportBigFiles.aspx for example code. The 64K row limit in 2003 cannot be changed. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Nainar" wrote in message ... Hi am using Excel 2003. I am in need to work / download data from SAP system into spreadsheet. I need to download about 2 lac rows of data into excel. whereas Excel 2003 allows me upto 65 odd thousand rows only ... How can I download / view this one ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get more than 65000 rows to display in Excel 2007 | Excel Discussion (Misc queries) | |||
| Data contains more than 65000 rows ? | Excel Worksheet Functions | |||
| Please help me with microsofts code to convert more than 65000 rows from text to excel | Excel Discussion (Misc queries) | |||
| Can I expand Excel workshhet beyond 65000 rows? | Excel Discussion (Misc queries) | |||
| How to get more than 65000 rows in and excel spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
