Changed recalculation after a named range, named function or table is added, changed or removed. Only the formulas that use names or table columns are rebound and recalculated; every other calculated value is kept. Previously every formula in the workbook was recalculated.
Changed recalculation after named range, named function and table changes
Only the formulas that use the changed name or table are recalculated; other calculated values are kept.