Set Calculation mode for a single worksheet

[Guest]

I'm setting up a complex worksheet that is taking a long time to run, due to
automatic calculation.

I'd like to setup Manual calculation just for this worksheet without
affecting all other open sheets. Is this possible?

Thxs!

 

[Bernie Deitrick]

Paulot,

Calculation mode is an application level setting, so: No, it is not possible.

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Paulot,

Calculation mode is an application level setting, so: No, it is not possible.

HTH,
Bernie
MS Excel MVP

 

[vezerid]

Hi.

Calculation settings affect the entire application. What you can do is
set the calculation to manual and then calculate this sheet only. You
can do this from the Calculation tab of Tools|Options, or with
Shift+F9.

Does this help?
Kostis Vezerides

 

[vezerid]

Hi.

Calculation settings affect the entire application. What you can do is
set the calculation to manual and then calculate this sheet only. You
can do this from the Calculation tab of Tools|Options, or with
Shift+F9.

Does this help?
Kostis Vezerides

 

[Guest]

Thanks anyway...

"Paulo A" escreveu:

 

[Guest]

Thanks anyway...

"Paulo A" escreveu:

 

[Dana DeLouis]

I'm setting up a complex worksheet that is taking a long time to run, due

to
automatic calculation.

Don't know if this idea would work for you.
In the vba editor, place the following code in the worksheet module of the
worksheet you would like to have set to Manual calculations.
The idea here is that when you select your particular sheet, Calculation
will be set to manual.
When you leave the sheet, it will be set back to automatic.

Private Sub Worksheet_Activate()
Application.Calculation = xlCalculationManual
End Sub

Private Sub Worksheet_Deactivate()
Application.Calculation = xlCalculationAutomatic
End Sub

 

[Dana DeLouis]

I'm setting up a complex worksheet that is taking a long time to run, due

to
automatic calculation.

Don't know if this idea would work for you.
In the vba editor, place the following code in the worksheet module of the
worksheet you would like to have set to Manual calculations.
The idea here is that when you select your particular sheet, Calculation
will be set to manual.
When you leave the sheet, it will be set back to automatic.

Private Sub Worksheet_Activate()
Application.Calculation = xlCalculationManual
End Sub

Private Sub Worksheet_Deactivate()
Application.Calculation = xlCalculationAutomatic
End Sub