why excel have 65536 row?

D

dlmckirdy

In the old 8 bit computers, 65536 was the maximum number of records that
could be handled. Its use as the limitation up until the present software is
just a legacy that required a complete re-coding of the software.
 
J

JNB

It's related to the design of the software and data size limitation. Merge
your data
in access then use pivot table to retrieve it from the database. I was able
to use
more than 200000 rows by this technique. After some googling, you can find
access code fragments for this purpose.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cells(my_crt_row,my_crt_col+1) crashes for my_crt_row>65536 4
Split a text file with more than 65536 lines over many worksheets 5
exceeding 65536 rows? 13
How to I expand the number of rows beyond 65536? 2
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
Excel --> Word 4
Last row on spreadsheet is row # 65536. How can I add more rows? 3
Repeating a row other than the 1st row as the header row in a table from next page 1

Top