• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Save Excel Without Formula Calculating?

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?
 
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!
 
This might help
In Thisworkbook module..

Code:
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


Untitled.png
 
Back
Top