I can only import 65,536 rows in Excel? I thought 2007 handled 1M

H

hdesoto

I thought Excel 2007 had 1 Million row capacity. but I can only import 65K.
Does anyone know why the difference?
 
B

Bernard Liengme

Sounds like you imported an XLS file (previous version of Excel)
Try making an XLSX file
Office Button | Convert and follow the clues
best wishes
 

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

Adding more than 65,536 rows in Excel 2007 5
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Excel 2007 - million rows 2
I have more than 65K rows when I open Excel 2007 2
Number of rows in Excel 2007 worksheets 3
Excel 2007 with no increase in rows and columns 2
How can I read over than 65,536 rows from excel spreed sheet 2
How to have more than 65,000 rows in excel 2007 3

Top