Forum Discussion
How can I set automatic formula calculation as a worksheet feature
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....
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 SubSwitch back to Excel.
Save the workbook as a macro-enabled workbook (.xlsm).
Your users will have to allow macros when they open the workbook.
HansVogelaar I need to be able to do this without VBA since users are often disallowed from running .xlsm files at their companies.
I'm sorry, but there is no way to enforce automatic calculation without VBA.
You might place an instruction in a cell on the worksheet that tells users to turn on automatic calculation.
