Forum Discussion

BECCOOP's avatar
BECCOOP
Occasional Reader
Sep 23, 2025

Excel formula stopped working

I have a work book with 6 sheets in it, tracking grain sales. Two sheets have stopped calculating the formula the more lines we use. I have to drag it across the cells to get it to calculate all of a...
community
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Sep 25, 2025

Quick checklist (try these first)

 

Calculation mode is set to Manual

Go to Formulas → Calculation Options → make sure Automatic is selected.

After switching to Automatic, press F9 (recalculate) or Ctrl+Alt+F9 (force full recalculation).

 

Excel was left in Manual by another workbook

Calculation mode can be carried between workbooks. Set it to Automatic, save the workbook, close Excel and re-open the file.

 

Table auto-fill / calculated column behaviour turned off (if you use Excel Tables)

File → Options → Proofing → AutoCorrect Options → AutoFormat As You Type → ensure “Fill formulas in tables to create calculated columns” is checked.

Also check File → Options → Advanced → Editing options → Enable fill handle and cell drag-and-drop and Extend data range formats and formulas.

 

If none of these helps, please provide precise details about the file. Excel version, operating system, storage medium, Excel file extension, and if possible, include the file (without sensitive data), so you can also see the formula.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

 

Was the answer useful? Mark as best response and like it!

This will help all forum participants.

Resources