Why-column-formula-not-update
Last Update: 10/28/2016
Origin 2017 has introduced a new, simplified Spreadsheet Cell Notation. When the cell notation is ON, indicated by the "A-Z" icon on top left of the worksheet, the column short names are locked and cannot be changed. Thus, when columns are inserted or deleted, the short name of the displaced column is automatically changed to maintain alphabetic order.
When spreadsheet notation is ON, the column formula will automatically update when inserting, deleting or moving columns or sheets, provided:
For a discussion of use of the Set Values dialog box to define column formulas, see Set Values Quick Start.
Keywords:set values, spreadsheet cell notation, col(), wcol(), F(x), column formula, column short name