I was going to state that for many people, the added rows and columns will
seem like a great reason to upgrade. The other issues, however, beg
otherwise.
This related anecdote may shed a little light.
I've never used a lot of database resources, though in many projects I've
interacted with CSV files. A recent project had multiple MB files with 50k
rows, well within Excel 2003's limits, but they were slow to import or to
open in
VB using my standard I/O techniques. I sat down with SQL for Dummies
and Google, and figured out how to deal with these files in ways that didn't
need 50k rows of my worksheet, and that ran in less than 1/10 the time. Now
I use SQL for the small files too: SQL lets me operate directly on the data
in the files, so I don't need to manipulate all these arrays in VBA.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
To echo the others, Excel 2007 will handle that number of rows of data.
To repeate what Jon Peltier said: with that much data, you may well be
better off using something like Access to warehouse the data and then
extract
what you need from it at any given time to perform operations with it in
Excel.
I've already had one client move to 2007 to get the added rows of data (he
had some files with close to 500,000 rows (2 columns only). The data
import
and minor manipulation we did with it went very well. But when we went to
trying to graph sections of the imported data (in the equivalent of 8800
row
groups) - charting brought the system to its knees. Would have been much
better to just deal with each of the 8800 data item groups individually,
probably.
"jason2444" wrote:
does anyone know if excel has an add on or if excel 07 will allow more
than
65,000 lines. I have files that are 250,000 + lines. if not excel can you
recommend another program?
thanks