Conditions for Setting Workbook Cell Locks due to a Formula

If the AUTO_LOCK_FORMULAS application preference is:

  • Defined and is checked, and the workbook cell contains a sample scheme analyte that has a Formula, when the workbook is opened, then the cell is automatically locked.
  • Not defined, or is defined and is cleared, when the workbook is opened, then the cell is not locked due to the presence of a formula, although it could be locked due to other conditions, for example, workflow status or expiry.