I've been working with Excel for about 8 months now, and i'm writing my own
VBA code and producing sheets that I thought would be impossible 3 months ago.

Now as I make more and more complex forms/charts/tables to accomplish more
difficult things i'm faced with, I see often "Calculating Cells" and have to
wait. Sometimes its a lengthy weight depending on the formulas.
I've also started using loops in macros to deal with lots of data, and each
time the macro does something it has to recalculate cells. In some instances
i've set it to not calculate automatically, and only do so when told to, but
this is inconvient on some sheets.

To give an example. One thing i've been doing is having a small Sumproduct
table, rather than a pivot table, I find it easier to use, and is more
accurate when automatically updated (the "Visit" column doesn't jump from D
to E) Unfortunatly, a couple of Sumproducts, or 1 lengthly one and its stuck
calculating.

I'm fully aware that the main problem with this may be the work server not
being powerful enough, either though the processing power allocated to my
terminal, or by the complexity of what i'm asking. But was wondering if
anyone knew of some simple (or even complex) ways to effectivily reduce the
Calculating time of spreadsheets.