Ok, I work daily with over 200K rows of data, and Excel just doesn't cut it for me anymore.
Is there even one software product that is capable of handling more than 64K rows on one sheet?
2006-09-27 07:17:44 · 4 answers · asked by Stan 2 in Computers & Internet ➔ Software
I am using Access but need to manipulate data in Excel as well.... :( I guess I could use Access for all my needs, but still, the question remains.
2006-09-27 07:23:54 · update #1
Get a beta copy of Office 2007 (aka Office 12) and the next version of Excel.
The changes in limits:
The total number of available columns in Excel
Old Limit: 256 (2^8)
New Limit: 16k (2^14)
The total number of available rows in Excel
Old Limit: 64k (2^16)
New Limit: 1M (2^20)
2006-09-27 07:22:40 · answer #1 · answered by Dr.Mr.Ed 5 · 0⤊ 0⤋
Try Microsoft Access.
Microsoft Excel 2007 (Excel 12) will give you more rows.
The total number of available rows in Excel
Old Limit: 64k (2^16)
New Limit: 1M (2^20)
2006-09-27 07:19:56 · answer #2 · answered by Anonymous · 0⤊ 0⤋
I'm not sure if there is a software that will allow you to do this, but I wold suggest that you cut down on the amount of data you need to have. If you really need that many columns, you might reconsider the database altogether.
Maybe MS Access would be a better software for you to use, instead of Ecxel.
2006-09-27 07:22:05 · answer #3 · answered by Ben D 3 · 0⤊ 0⤋
Quattro Pro limit is 1.000.000
and can manage any kind of database
and Wordperfect office is way cheaper than MSoffice.
2006-09-27 07:33:09 · answer #4 · answered by guido_961 4 · 0⤊ 0⤋