Rows in an Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top