f2e4
08-13-2008, 09:22 AM
I have 3 sheets full of formulas that only need to be refreshed / calculated when I run a specific macro.
However, everytime I save my file, excel begins the calculation process, and i'm left sitting there for a few mins while it does its thing.
Is anyone aware of a way of preventing excel doing this?
I thought it would be as simple as:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.Calculation = xlManual
End Sub
This doesn't even work
However, everytime I save my file, excel begins the calculation process, and i'm left sitting there for a few mins while it does its thing.
Is anyone aware of a way of preventing excel doing this?
I thought it would be as simple as:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Application.Calculation = xlManual
End Sub
This doesn't even work