Disable Calculation of One of the Sheets

[Ceeyee]

Hi,

I have a worksheet with formulas getting data from other sheets (only inflows), but no other sheets need data from this sheet (no outflows).

I don't use this sheet often, but it has a lot of formulas in there and it slows down the workbook when other sheets calculate as they will update this sheet as well.

Is it possible to disable the calculation of the formulas in this sheet (only), until I enable it again?

Thanks.

 

[AlphaFrog]

These two macros will Disable\Enable calculations on only Sheet3. Change the sheet name in the code to suit.

Sub Disable_Calculations_Sheet3()
   Sheets([COLOR="Red"]"Sheet3"[/COLOR]).EnableCalculation = False
End Sub

Sub Enable_Calculations_Sheet3()
    Sheets([COLOR="Red"]"Sheet3"[/COLOR]).EnableCalculation = True
End Sub

 

[Ceeyee]

Thanks.

 

[Ceeyee]

If we set .EnableCalculation = False but do not set it back to True, and we close the workbook.
When we reopen the workbook, would the False still be effective?

Can this .EnableCalculation parameter also be used on a range?

Thanks.