Google Answers Logo
View Question
 
Q: Excel ( Answered,   1 Comment )
Question  
Subject: Excel
Category: Computers > Software
Asked by: aalltheway-ga
List Price: $2.00
Posted: 05 Jan 2006 21:23 PST
Expires: 04 Feb 2006 21:23 PST
Question ID: 429805
How many rows can an excel spreadsheet contain.  Mine goes to about
65,000 and I need about 500,000, or more.
Answer  
Subject: Re: Excel
Answered By: efn-ga on 05 Jan 2006 23:24 PST
 
Hi aalltheway,

An Excel 2003 spreadsheet can contain up to 65,536 rows.

Reference:

Excel specifications and limits
http://office.microsoft.com/en-us/assistance/HP051992911033.aspx

An older version is unlikely to support more rows.  A database program
might be more suitable for your application.

--efn
Comments  
Subject: Re: Excel
From: doctorpaul-ga on 06 Jan 2006 06:01 PST
 
Almost without a doubt a database of some type would be more efficient
for 500,000 rows of information. Whilst the theoretical limit of Excel
(and Lotus 123 before it) is 65,535 the efficiency of any spreadshhet
will decay long before the row limit is reached. This is because the
spreadshet program has to rescan each and every row and column to
recalculate formulae and sumations.

As a rule of thumb: If your spreadsheet is too large to scroll from
one end to the other in less than 10 seconds then it is probably not
the best way of storing your data.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy