Set Calculation mode for a single worksheet
 

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!

Set Calculation mode for a single worksheet
 

Paulot,

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

HTH,
Bernie
MS Excel MVP


"Paulo A" wrote in message
...
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!

Set Calculation mode for a single worksheet
 

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

Paulo A wrote:
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!

Set Calculation mode for a single worksheet
 

Thanks anyway...

"Paulo A" escreveu:

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!

Set Calculation mode for a single worksheet
 

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


--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Paulo A" wrote in message
...
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!