• 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.

Disabling automatic calculations on excel sheets

A

AshutoshSethi

New Member
Hi, I am not an expert user of excel but get my way around it.

I have disabled all automatic calculations on my excel, but everytime I get a new excel sheet from someone, it starts calculating automatically; most of our models are 30MB+ in size (leaving that painful issue behind) and automatic calculation (or automatic calculation before saving, just kills the system).

Is there a way or a simple macro that can run on excel startup (or if my excel is already started), disable the auto calculation for all sheets unless manually asked to do so?

apologies if it is a naive question.

Thanks,
Ashu
 
Hey, this is quite basic and I have done all those steps; there is a continuing problem with the new workbooks that other people send me, which are not defaulted to that option; once I open those books, it calculates automatically those workbooks..
 
You just need to open the said workbook from same instance of Excel (instead of clicking on file, open from Excel dialog).

Any workbook opened from workbook set on manual mode will inherit the setting.

So, open blank workbook, go to Formulas ribbon and set it to manual and then, go to file menu and open the downloaded workbook.
 
I did try that actually and did that for two days..the new workbook is not inheriting the parents's properties? can that happen only for my version of MS office? anything that i can do to change this?
 
Try to save this code to 'ThisWorkbook' and check.
Code: 
Private Sub Workbook_Open()
    Application.Calculation = xlCalculationManual
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.Calculation = xlCalculationAutomatic
End Sub
 
You must log in or register to reply here.
Back
Top