Solved

Increasing the Maximum Number of Rows on an Excel Spreadsheet

Posted on 2001-06-08
4
912 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

636 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