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

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

Regards,
Stefi


„(E-Mail Removed)â€� 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
>
>

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
>
>
> ,,(E-Mail Removed)" 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
> >
> >

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

"(E-Mail Removed)" 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
> >
> >
> > ,,(E-Mail Removed)" 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
> > >
> > >
>
>