[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 923
  • Last Modified:

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.
0
ajb3
Asked:
ajb3
  • 2
1 Solution
 
criCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now