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