AUTO_LOCK_FORMULAS

BOOLEAN

When a workbook is opened interactively or non-interactively, and a cell contains a formula from the analyte, then:

  • If checked (default on deploy; default if missing), then the workbook cell is locked, and its result can only be updated based upon the execution of the formula.
  • If cleared, then the workbook cell are not locked.

Note: The ALLOW_UNLOCK_FORMULAS application preference determines whether you can unlock a cell containing a formula.

Related Processes