Solved

Increasing the Maximum Number of Rows on an Excel Spreadsheet

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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adding Additional Criteria to a formula 17 49
V-Lookup 11 21
Countdown Timer Advanced 5 23
Assign a value in Excel V-Basic 3 6
This article will show you how to use shortcut menus in the Access run-time environment.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

820 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