Increasing the Maximum Number of Rows on an Excel Spreadsheet

I am trying to import information into an Excel spreadsheet for further analysis but can only import 65,536 row - it tells me that all information has not been imported.

Does anyone know how (or if) I can increase the number of rows (substantially) past this limit.
ajb3Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
criConnect With a Mentor Commented:
Sorry, you can not.

The only workaround is to split the data into separate worksheets or distribute it to several columns. How many lines do you have ? Are there blank rows which could be deleted before ?
0
 
ajb3Author Commented:
Unfortunately there are no blank rows at all.
0
 
Anne TroyEast Coast ManagerCommented:
ajb3, it's time to move your data into Access. I don't say this because I'm an Access person (which I'm not really), but because Access will handle this far better than Excel. Let us know if you need help with that.
0
 
criCommented:
ajb3, I should have known from your grading record...>8-(

 I   a m   n o t   r e s p o n s i b l e   f o r   M i c r o s o f t   l i m i t s  !

See also http://www.experts-exchange.com/jsp/cmtyQuestAnswer.jsp#3
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.