Forum Discussion
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 sudden instead of it auto-calculating.
Im not sure if its a rounding issue that causes it to stop working? I was told previously that this has happened and thats what they thought it was, but the girl at my work that created the spreadsheet, is no longer here. My boss doesnt remember how to fix it. Any ideas?
2 Replies
If the suggestions from NikolinoDE don't resolve the situation, you could help us help you by posting a copy of the actual workbook (so long as its contents are not confidential or proprietary). If the latter is the case, perhaps you could create a replica without the confidential/proprietary components.
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.
