How can I set automatic formula calculation as a worksheet feature

%3CLINGO-SUB%20id%3D%22lingo-sub-2268294%22%20slang%3D%22en-US%22%3EHow%20can%20I%20set%20automatic%20formula%20calculation%20as%20a%20worksheet%20feature%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2268294%22%20slang%3D%22en-US%22%3E%3CP%3EMS%20Excel%20gives%20me%20a%20possibility%20to%20set%20a%20way%20how%20formulas%20are%20calculated%2C%20either%20automatically%20or%20manually%20(FILE%20-%26gt%3B%20OPTIONS%20-%26gt%3B%20FORMULAS%20-%26gt%3B%20Calculation%20options%20-%26gt%3B%20Workbook%20Calculations).%3C%2FP%3E%3CP%3EIt%20is%20clear.%20It%20is%20MS%20Excel%20settings%20on%20each%20particular%20comp.%3C%2FP%3E%3CP%3EI%20create%20forms%20for%20other%20users.%20Many%20of%20them%20have%20MANUAL%20FORMULAS%20CALCULATION%20option%20set%20on%20their%20comps.%20It%20is%20not%20possible%20to%20manage%2Fexplain%20to%20everybody%20to%20have%20AUTOMATIC%20FORMULA%20CALCULATION%20set%20on%20their%20comp.%3C%2FP%3E%3CP%3EI%20somehow%20need%20to%20add%20AUTOMATIC%20FORMULA%20CALCULATION%20as%20a%20feature%20of%20my%20worksheet.%3C%2FP%3E%3CP%3EI%20need%20to%20arrange%20for%20an%20automatic%20formula%20recalculation%20in%20my%20worksheet%20even%20on%20other%20comps%20having%20manual%20formula%20calculation%20settings.%20Like%20a%20fool-proof%26nbsp%3Bprovision%20against%20those%20form%20users%20who%20keep%20manual%20formula%20calculation%20settings%20in%20their%20Excel%20options.%3C%2FP%3E%3CP%3EAny%20idea%3F%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20basic%20settings%20I%20missed%3F%3C%2FP%3E%3CP%3EDeveloper%20tool%3F%3C%2FP%3E%3CP%3EVBA%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2268294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

MS Excel gives me a possibility to set a way how formulas are calculated, either automatically or manually (FILE -> OPTIONS -> FORMULAS -> Calculation options -> Workbook Calculations).

It is clear. It is MS Excel settings on each particular comp.

I create forms for other users. Many of them have MANUAL FORMULAS CALCULATION option set on their comps. It is not possible to manage/explain to everybody to have AUTOMATIC FORMULA CALCULATION set on their comp.

I somehow need to add AUTOMATIC FORMULA CALCULATION as a feature of my worksheet.

I need to arrange for an automatic formula recalculation in my worksheet even on other comps having manual formula calculation settings. Like a fool-proof provision against those form users who keep manual formula calculation settings in their Excel options.

Any idea? 

Some basic settings I missed?

Developer tool?

VBA?

Thanks.

2 Replies

@JS_questions 

You can do the following:

Press Alt+F11 to activate the Visual Basic Editor.

Double-click ThisWorkbook under Microsoft Excel Objects in the left-hand pane.

Copy the following code into the workbook module:

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

Switch back to Excel.

Save the workbook as a macro-enabled workbook (.xlsm).

 

Your users will have to allow macros when they open the workbook.

Thank you Hans, will try and let you know. Have a nice day.