Stupid Question

spg2112 · Mar 6th, 2002, 12:43 PM

Why does Excel limit us to 65,536 rows? I blow that away all the time, and usually have to filter something out to get it on a sheet. It seems like Mr. Gates could get us 100,000 rows rather easily.

Is it more of a clipboard cache problem or what?

Mark W. · Mar 6th, 2002, 01:20 PM

Its a memory issue (64K = 1,024 x 64 = 65,536). Remember when opened an entire workbook must reside in memory. If you need more that 65,536 rows you should be looking at a DBMS.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 12:43 PM	#1
spg2112 Board Regular Join Date: Feb 2002 Location: Dallas, TX Posts: 312	Why does Excel limit us to 65,536 rows? I blow that away all the time, and usually have to filter something out to get it on a sheet. It seems like Mr. Gates could get us 100,000 rows rather easily. Is it more of a clipboard cache problem or what?

Mar 6th, 2002, 01:20 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Its a memory issue (64K = 1,024 x 64 = 65,536). Remember when opened an entire workbook must reside in memory. If you need more that 65,536 rows you should be looking at a DBMS.