Rows in an Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What limits the size of an Excel worksheet
Why 65537 columns and 256 Rows?
 
By how many bits it takes to store the number of rows or columns.
256 is 2^8 (one byte)
65536 is 256 x 256 or 2^16 (two bytes)

To change this would take a redesign of Excel and almost
certainly much bigger files. So it is a "Specification Limit"
and you will find "specification limits" if you look in HELP.-
 
Ashima

I'm afraid that it is the design. the limit is considered
a reasonable size for a spreadsheet. You can split data
accross worksheets if necessary.

If you are using Excel as a large database for say 200k
parts you would be better using a proper database such as
Access or FoxPro

Regards
Peter
 
You must log in or register to reply here.

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

#REF! error when copying formula beyond row 65536 in Excel 2007 1
Row Limit 65536 6
Compatability Mode 1
Numbers in Excel columns? 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
saving files 1
JOIN 3 Excel 07 worksheets 0
Excel/XML File Limitations 2

Back
Top