Calculations

[Guest]

Is there a way to set Excell to automatically update calculations is most
workbooks, but be set as manual in others?

 

[Gord Dibben]

Josh

Since Excel takes the calculation mode from the first workbook opened during a
session, the only sure way to set calculation mode for a particular workbook
would be through code that runs when a workbook is opened or activated.

Private Sub Workbook_Activate()
Application.Calculation = xlCalculateManual
Application.Calculation = xlCalculationAutomatic
End Sub

Private Sub Workbook_Open()
Application.Calculation = xlCalculateManual
Application.Calculation = xlCalculationAutomatic
End Sub


Gord Dibben Excel MVP