Problem: Excel formula is not calculating automatically
For example, you try to flash fill a formula down a column and Excel copies the first cell’s contents down the column instead.
A likely reason is that the formula ‘Calculation Options‘ setting is on ‘Manual‘ rather than the default ‘Automatic‘.
![Screenshot of calculation options menu items in Excel](https://excelquick.com/wp-content/uploads/2020/01/calculation-options-excel-quick-help.png)
Find Excel’s Calculation Options on the ‘Formulas’ tab of the ribbon.
![Screenshot of formulas tab on Excel's ribbon.](https://excelquick.com/wp-content/uploads/2020/01/formulas-tab-excel-ribbon.png)
Related topics
- Flash fill a column: copy a cell’s contents, series or formula down a column