Poor calculation speed affects productivity and increases user errors.
Studies have shown that a user's productivity and ability to focus on
a task
deteriorate as response time lengthens.
Excel has two main calculation modes, which let you control when
calculation occurs:
* Automatic calculat
Thanks for your suggestions/help. I checked to make sure that all of
the loops use "Exit For" when appropriate. I am using Excel 2007 which
*could* be causing some of the slowdown, but Excel only really comes
in at the end for result output, it could explain why my speed tests
are so slow (I've bee
It's the "without looking at the code" part that makes it difficult !!!
There are LOTS of ways to speed up loops, but everything
doesn't always apply!
first of all, what version of Excel are you using?
Excel2007 has a way of dropping to a lower priority after several seconds,
thus causing long ru
