Not sure if this is helpful, but just double check that the auto calculation is turned on (Excel 2010):

File>Options>Formulas +check that the radio button for "Automatic" is selected.