Recent searches
Search options
Someone here once told me of how Microsoft had these customers who pay $$$ so a real driving force in the development of Excel are these horrific, unspeakable, monstrosities of spreadsheets critical to the operations of some very serious companies, serious bookkeeping, serious material operations. The elderich horror spreadsheets are decades old, have 100,000s of rows, spaghetti code formulas— Microsoft always checks updates will not harm them. IDK. if it was true: but it *felt* true.
@futurebird Excel has a limit of 32k rows, at which point one has to migrate the spreadsheet over to database Access or SQL
@Sean Really? Ok so I must be wrong about the rows! I thought they expanded it for some reason.
@sabik @futurebird @Sean Yeah, I was gonna say, I’m sitting here with a 300k+ row sheet open as we speak
@eaton @sabik @futurebird @Sean
Excel 2000 (with ".xls" files) is limited to 65536 rows and 256 columns and 255 worksheets.
And that has caused problems for systems that "could not be upgraded" ... for a Very Long Time. 
@futurebird @Sean Until 2007, Excel had a limit of 65,536 rows. It was expanded to a million rows with the new .xlsx format. The old .xls format (which some software still output) still have the 65k rows limit.
@vl_tone @futurebird I was way off (100% greater limit than I thought it was) with that old limit. Thanks for the correct information.