Formulas are not working/updating
 

I noticed about a week ago that none of my formulas in any of my worksheets
are updating - meaning that if I change a number in a column that is being
summed, the sum will not change. This applies to ALL of the formulas I
create in Excel. Did I change a setting in Excel that I don't know about?

Formulas are not working/updating
 

Check Tools-Options on the calculation tab make sure it is set to Automatic.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"TexasIndoorGolf" wrote:

I noticed about a week ago that none of my formulas in any of my worksheets
are updating - meaning that if I change a number in a column that is being
summed, the sum will not change. This applies to ALL of the formulas I
create in Excel. Did I change a setting in Excel that I don't know about?