Docs

Rename & references

If a formula can reference a name, renaming that name rewrites the formula.

Triggers

Renaming a table header
Renaming a list index
Locked nested tables: one rename updates the template, siblings, and every formula that targeted any of them

What rewrites

Cell formulas and colFormula across the workbook
Shared locked-column formula templates
Only path segments that resolve to that field on that structure (identity-aware)

Examples

Total = Q1.+Q2.
Rename Q1 → Revenue
  → Total becomes =Revenue.+Q2.
  → =SUM(Budget.Q1) becomes =SUM(Budget.Revenue)

List index Budget → Spend
  → =SUM(Budget.Total) becomes =SUM(Spend.Total)

Grid A1 addresses are positional. Insert/delete still shifts relative refs with $ locks. That is separate from name rewrite.