| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I increase the limit on the number of import rows in Excel
Hi,
Does anyone know how to increase the number of rows that Excel can import or read? My version is XP pro. Now the limit is about 65000 rows. I have data sheet that is much more than that. Thank you. Aleck |
|
#2
|
|||
|
|||
|
hi,
65536 is the max. hard coded into excel. in xl help type specifications for more details -----Original Message----- Hi, Does anyone know how to increase the number of rows that Excel can import or read? My version is XP pro. Now the limit is about 65000 rows. I have data sheet that is much more than that. Thank you. Aleck . |
|
#3
|
|||
|
|||
|
You could split your data into 2 or more sheets
"Aleck" wrote: Hi, Does anyone know how to increase the number of rows that Excel can import or read? My version is XP pro. Now the limit is about 65000 rows. I have data sheet that is much more than that. Thank you. Aleck |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a limit to the number of rows that can be filtered | Excel Worksheet Functions | |||
| Increase rows in worksheet beyond 65,536 row limit | Excel Discussion (Misc queries) | |||
| How do I limit the number of complete sentences in a spreadsheet c | Excel Worksheet Functions | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| Increase the limit to number of columns? | Excel Discussion (Misc queries) | |||
Linear Mode
