Under Tools>Options>Calculations is it set to "Automatic"?