Change formula recalculation, iteration, or precision in ...
This is the default calculation setting. To recalculate all dependent formulas — except data tables — every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook Calculation, click Automatic except for data tables.