Excel Formulas

Copper Contributor
Lately, I've noticed that in Excel, my formulas don't continue to add or do the other formula functions.  Any idea why?
 
In the past, if I put a one in a column, it would automatically add it.  The formulas are all set up as such.  For some reason, it isn't calculating and after a add more data, I have to re-install the same formula.  
 
Also, I used to format the first line for the formula then copy and paste the formula and it figured out that I am adding the second line, etc.  It doesn't do any of that now.  I'm also finding this occurring in other spreadsheets all of the sudden.
 
Did Excel change or is there a setting that might inadvertently do this?
 
1 Reply

Hello @lroody,

have you checked your 'Calculation Option' under 'Formula' tab?

Rr__0-1706596480688.png

it should be on 'Automatic'.