Yes, there's a lot of data but also a lot of calculations, pivots and
transformations. However, I think you're right that it's time to use Access
for some or all of the functions, even though it's less convenient and I
don't speak the language (yet).
--
RP


"Alan" wrote:

Not having Excel 2007 yet, I don't know if it would handle this better, I
suspect it would though.
In the older versions which I use too, a file of 145MB and 63,000 lines I
think is pushing it. Presumably most of the file is data which is stored and
a relatively small amount is taken up with formulas, pivots, graphs etc.
I may be wrong but I've always understood that Excel should be used for
calculations etc and not as a database. If you stored the static data in
Access for instance and had Excel refer to an Access file instead of storing
it all in the Excel file itself you may get better results.
I'm making assumptions here as to what is in your huge file I know. If I'm
wrong, please just ignore this,
Regards,
Alan.
"Robin P" wrote in message
...
I'm running into really bad performance problems with Excel 2002.
Problem 1: - Have a workbook with multiple worksheets approx 145MB and
now
approaching 63,000 lines. Excel often "cannot complete with available
resources", can only paste limited data to clipboard even when empty,
cannot
sort or - in some cases - filter.

Problem 2: - more intriguing; I have a text file created from another
application that's only 50MB, also 63,000 lines with 30 columns, that
takes
an hour to open.

I'm using a Dell Latitude D600, 1.6GHz processor with 2GB RAM, so memory's
not a problem.

Does anyone have any advice and/or know if Excel 2007 will perform better?
--
RP