Forum Discussion

lroody's avatar
lroody
Copper Contributor
Jan 29, 2024

Excel Formulas

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

  • Rodrigo_'s avatar
    Rodrigo_
    Steel Contributor

    Hello lroody,

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

    it should be on 'Automatic'.