Manual Recalculate

[Peter100]

I have a multi sheet workbook, with one worksheet containing a large multi sumif statement which takes a long time (relatively speaking) to calculate.

I want to disable the the auto re-calculate in this sheet ONLY.

I then want to recalculate it when a macro is run.

Any Ideas ?

 

[Ivan F Moala]

On 2002-08-31 23:30, Peter100 wrote:
I have a multi sheet workbook, with one worksheet containing a large multi sumif statement which takes a long time (relatively speaking) to calculate.

I want to disable the the auto re-calculate in this sheet ONLY.

I then want to recalculate it when a macro is run.

Any Ideas ?

Application.Calculation = xlCalculationManual

'// Do your thing
'// Calculate just your sheet
Worksheets(1).Calculate

 

[Sir Vili]

Hello Peter100.

I use in my tables these VBAs:

Sub Calc_Off()
With Application
.Calculation = xlManual
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub

Sub Calc_On()
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = True
End Sub

When starting macro put Calc_off macro and at end put Calc_on macro.

BRGDS Sir Vili.

 

[Peter100]

Hi Ivan

Won't that turn off auto calculation in all sheets and then only calculate the specified worksheet ?

Or am I reading it incorrectly


Sir Vili

I will try this out

 

[Ivan F Moala]

On 2002-09-01 00:41, Peter100 wrote:
Hi Ivan

Won't that turn off auto calculation in all sheets and then only calculate the specified worksheet ?

Or am I reading it incorrectly


Sir Vili

I will try this out

Peter, yes you are correct, should read the Q