Forum Discussion
Formulas don't work unless click fx, then approve it by clicking OK.
1. Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
2. As long as you have circular references, Excel will not recalculate many formulas.
Does the status bar provide a clue? Sometimes it displays the address of a cell that causes a circular reference. You can also try Error Checking > Circular References on the Formulas tab of the ribbon.
1. Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
2. As long as you have circular references, Excel will not recalculate many formulas.
Does the status bar provide a clue? Sometimes it displays the address of a cell that causes a circular reference. You can also try Error Checking > Circular References on the Formulas tab of the ribbon.
- fI was able to fix the circular references, but your suggestion to set Calculations Options to Automatic immediately fixed the problem. Mine had gotten set to "Manual". I don't understand why that was the problem, but it is fixed now. Thanks so much!
