Excel record limit?

's Computer Specifications

Can somebody confirm that Excel has a limit of 50.000 records? (Excel 2000
or Excel 2003)

's Computer Specifications

If you by record mean row, the limit is exactly 65536.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Luis Miguel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Can somebody confirm that Excel has a limit of 50.000 records? (Excel 2000
> or Excel 2003)
>
>

's Computer Specifications

Hi Luis,

Expect you mean 65,536 rows, which is the maximum rows that have
ever been in Excel and is true for in Excel 2000 and Excel 2003
which you asked about. (I see Harald beat me, what I lack in quality
I'll try to make up for in quantity).

You can read about Specific Limits in the Excel Help.
HELP (F1), index (tab), specification
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luis Miguel" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Can somebody confirm that Excel has a limit of 50.000 records? (Excel 2000
> or Excel 2003)
>
>

's Computer Specifications

The quality could have been improved if I spelled words correctly the
first time instead of accepting the offerings of the spell checker.
I meant "Specification Limits" rather than "specific limits".

>
> You can read about Specific Limits in the Excel Help.
> HELP (F1), index (tab), specification

's Computer Specifications

Thanks. Is there any way to pass this limit?

"David McRitchie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The quality could have been improved if I spelled words correctly the
> first time instead of accepting the offerings of the spell checker.
> I meant "Specification Limits" rather than "specific limits".
>
> >
> > You can read about Specific Limits in the Excel Help.
> > HELP (F1), index (tab), specification
>
>
>

's Computer Specifications

"Luis Miguel" <(E-Mail Removed)> skrev i melding
news:(E-Mail Removed)...
> Thanks. Is there any way to pass this limit?

No.
No as in "not with Excel". You might try Quattro Pro, a Database program or
a plain oldfashioned text file instead.

Best wishes Harald

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Form code: how do I run code every time a record is "loaded" by going to next record, last record, etc.	Dave R.	Microsoft Access Macros	1	24th Jun 2005 07:37 PM
Update record - returns to the first record in the record set	Kim	Microsoft Access Forms	0	22nd Apr 2005 04:20 PM
Current Record Count, Previous Record #, Add New Record	=?Utf-8?B?Um9iZXJ0IE51c3ogQCBEUFM=?=	Microsoft Access Forms	0	15th Feb 2005 09:35 PM
Sub record not associated with main record when copy record button is used	Ron V	Microsoft Access Form Coding	0	21st May 2004 05:26 PM
I am trying to get a form to pick up the record data from a different record to this new record	Thomas Simsion	Microsoft Access Forms	4	10th Nov 2003 10:48 PM