Stop Excel from evaluating formulae unless I want it to
 

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

Stop Excel from evaluating formulae unless I want it to
 

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

Stop Excel from evaluating formulae unless I want it to
 

is that a global setting for the entire workbook or will that just
apply to that sheet?

Thanks

Jamie

Stefi wrote:
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

Stop Excel from evaluating formulae unless I want it to
 

Unfortunately it's a global setting. You can manipulate it in the way you
request with a Workbook_SheetActivate event sub:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "name_of monster_sheet" Then
Application.Calculation = xlManual
Else
Application.Calculation = xlAutomatic
End If
End Sub

Regards,
Stefi

" wrote:

is that a global setting for the entire workbook or will that just
apply to that sheet?

Thanks

Jamie

Stefi wrote:
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