MS Excel worksheet has limit of 65,536 rows. Can they be increased. If not what the alternatives can be, say the need is of 500,000 observations which must be continuous.
2007-10-05 18:54:14 · 4 answers · asked by spring t 1 in Computers & Internet ➔ Software
Get a database designer to build you an interface for your data in MySQL or Oracle -- you could then handle millions of "row" like structures.
2007-10-05 19:01:53 · answer #1 · answered by ★Greed★ 7 · 0⤊ 0⤋
I think Excel 2007 has more rows than Excel 2003, however I don't know if it has that many rows. You might continue your data on the next spreadsheet. However if you have that much data, a database is more situated to suiting your needs.
2007-10-09 10:11:23 · answer #2 · answered by devilishblueyes 7 · 0⤊ 1⤋
*Greed* is correct. For that much data you should use a database instead. However, if you MUST use a spreadsheet, then upgrade to Excel 2007. It has over a million rows.
Tim
http://www.tvmcalcs.com
2007-10-07 01:33:45 · answer #3 · answered by Tim 4 · 0⤊ 0⤋
if i'm not mistaken even excel 2003 has more than a million rows
2007-10-06 02:05:50 · answer #4 · answered by sonuo280330 2 · 0⤊ 2⤋