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 - 28 Sep 2006 02:14 GMT
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
-----------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/profile.php?mode=viewprofile&u=
View this thread: http://www.exceljockeys.com/forums/viewtopic.php?t=30766
Roger Govier - 28 Sep 2006 08:18 GMT
Hi
Take a look at Charles William's site for help on tracing bottlenecks
and gaining speed improvements.
http://www.decisionmodels.com/

Signature
Regards
Roger Govier
> Hi There,
>
[quoted text clipped - 12 lines]
>
> Thanks.
Huff - 28 Sep 2006 11:03 GMT
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
> Hi There,
>
[quoted text clipped - 12 lines]
>
> Thanks.