PDA

View Full Version : manual recalculation not for all sheets in wb



danovkos
05-03-2010, 04:16 AM
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
05-03-2010, 06:21 AM
Try this:

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

And in the specific worksheet code put in:

Private Sub Worksheet_Activate()
With ActiveSheet
.Calculate
end with
End Sub


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

HTH

Lincoln

danovkos
05-03-2010, 06:53 AM
Try this:

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

And in the specific worksheet code put in:

Private Sub Worksheet_Activate()
With ActiveSheet
.Calculate
end with
End Sub


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

HTH

Lincoln
ok ill try it
thx