File/Options/Formulas. Calculations should be set to Automatic.
Sometimes, one workbook can be set to manual. Formulas/Calculation Options.