Excel 2002 performance

[Guest]

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?

 

[Guest]

Check to see if index service is operating. The can easily be checked in the
Task Manager. Look for CISVC.exe. Try killing process and see if the file
opens any quicker. Index service is suppose to speed up opening files but in
some cases it slows things down considerably because Indexing uses a lot of
memory. If you do a search on the web for Indexing and CISVC.exe you find a
lot of information.

 

[Alan]

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.

 

[Charles Williams]

you can find advice on both memory/resource problems and calculation
optimisation at my website.
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

 

[Guest]

Not running so didn't help, but will keep an eye out for the future. Thanks.

 

[Guest]

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).

 

[Guest]

I'd checked your website before posting and not found anything there; but
thanks for the reply.