manual recalculation not for all sheets in wb

[danovkos]

Hi all,
pls. is it possible to do following?

I have big wb with many sheets. In some of them i have sumproduct formulas, which always calculate (if is autocalculation turned on) with my huge data (6000 rows x 30 col). I think, thats ths reason, why it takes me a long time, if i want only to filter my huge data or so.

Because this i want to turned off recalculation for my sumproduct formula sheets. I will turned on only manualy with button. But whole wb will be calculating ad default (automaticaly)

How can i do that?

thx a lot.

[lynnnow]

Try this:

Set the Automatic Calculation (Tools>Options>Calculation) to Manual

And in the specific worksheet code put in:

[vba]Private Sub Worksheet_Activate()
With ActiveSheet
.Calculate
end with
End Sub
[/vba]

This should calculate that particular sheet when the sheet is activated.

HTH

Lincoln

[danovkos]

Try this:

Set the Automatic Calculation (Tools>Options>Calculation) to Manual

And in the specific worksheet code put in:

[vba]Private Sub Worksheet_Activate()
With ActiveSheet
.Calculate
end with
End Sub
[/vba]

This should calculate that particular sheet when the sheet is activated.

HTH

Lincoln

ok ill try it
thx