Solved

Increasing the Maximum Number of Rows on an Excel Spreadsheet

Posted on 2001-06-08
4
910 Views
Last Modified: 2009-12-16
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.
0
Comment
Question by:ajb3
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
cri earned 75 total points
ID: 6167335
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
 

Author Comment

by:ajb3
ID: 6167349
Unfortunately there are no blank rows at all.
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 6167366
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
 
LVL 13

Expert Comment

by:cri
ID: 6167750
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

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question