Tools/Options/Calculation tag/Check Calculation-On request only!

Regards,
Stefi


€� ezt Ã*rta:

Hi All,

I've just had to create a monster sheet that essentially enables me to
do a SUMIF over 2 criteria, however there's some 15,000 cells involved
in this new sheet and it really slows the workbook down on startup and
every time it re-evaluates the formulae.

Is there any way that I could set just that sheet so that it doesn't
re-evaluate the formulae unless I ask it to (by means of a prompt or
any other method)?

Thanks

Jamie