Save Excel Without Formula Calculating?

[Mike Langlois]

Hi all,

I have a spreadsheet that has a very extensive series of formula in. So much so that when I process it, it starts to not respond and crash Excel.

I want to save the file (so I don't lose my work) but every time I save it, it recalculates. When it recalculates, it crashes. When it crashes, it restores the file without saving.

I am stuck not being able to save this file, is there a way to save a file without it processing all formula, so I can save it, and then get in and fix it?

 

[rrocker1405]

Hi Mike,

Follow the below steps for excel 2010 and above

File > Options > Formulas > [calculation options] > uncheck the box which reads recalculate workbook before saving.

This should do the trick.

Kind regards,
A!

 

[Deepak]

This might help
In Thisworkbook module..

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.Calculation = xlCalculationManual
    ThisWorkbook.Close False
End Sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Application.Calculation = xlCalculationManual
End Sub

or