Speeding up Excel - Large amounts of data, no complex formulas

[tbrowne]

Hi There,

I am currently investigating what is the most cost effective way of
speeding up excels calculations for large spreadsheets. The sheets do
not contain what I would consider to be overely complex formulas with
the main tools being VLOOKUP, with maybe a few nested IF statements.
No complex maths as it mainly database manipulation type activity.

Currenlty it is taking too long to recalculate and even with manual
calculation enable is proving to be a hinderance to productivity. I
was wondering if this is solvable by building a more suitable PC unit
or if the best way to go about it lies outside upgraded hardware. If
it is hardware, what sort of components should I be looking at for an
excel screamer.

Thanks.

 

[ExcelJockey]

without knowing the details..

possibilities, get more RAM for your PC or upgrade the whole box, fin
and fix the bottlenecks (google "excel spreadsheet recalculatio
bottlenecks" for analysis tools) by rewriting the slow parts, o
if the spreadsheet is really massive, consider distributing th
computation using the features of the upcoming Office 12

 

[Roger Govier]

Hi

Take a look at Charles William's site for help on tracing bottlenecks
and gaining speed improvements.
http://www.decisionmodels.com/

 

[Huff]

Probably a better bet would be to import the sheets into Access (or
another database application) and perform the calc's in there. Would be
a lot faster, and probably as cheap as building a better PC...

Cheers