excel - Cells not updating automatically - Stack Overflow To change this to automatic in the various versions of Excel: 2003: Tools ... 2010: File > Options > Formulas > Workbook Calculation > Automatic. On Mac:.