How do I increase the limit on the number of import rows in Excel

G

Guest

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
 
G

Guest

hi,
65536 is the max. hard coded into excel.
in xl help type specifications for more details
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to increase the max number of rows in Excel spreadshee above 6 2
import multiple excel books to one excel workbook 3
increase total rows 2
65000 limit 4
how to increase no. of rows in excel spreadsheet 2
How do I import data into Excel that exceeds 70000 rows? 2
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Increase rows in worksheet beyond 65,536 row limit 2

Top