Calculation settings

Practical: how to change one cell and update all formulas in Excel

Put a value in one input cell, point your formulas at it, and know what to check when Excel refuses to recalculate.