SOLVED
Home

Formulae do not recalculate automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-180226%22%20slang%3D%22en-US%22%3EFormulae%20do%20not%20recalculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180226%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20never%20had%20this%20happen%20before.%26nbsp%3B%20I%20change%20raw%20data%20in%20a%20spreadsheet%20and%20related%20calculated%20cells%20do%20not%20automatically%20recalculate.%26nbsp%3B%20They%20only%20recalculate%20after%20I%20go%20into%20each%20cell%20and%20then%20into%20the%20formula%20bar%20and%20hit%20enter.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20only%20thing%20I%20can%20recall%20that%20I%20did%20recently%20to%20this%20spreadsheet%20was%20Check%20for%20issues%20%26gt%3B%20Inspect%20workbook.%26nbsp%3B%20Could%20that%20have%20caused%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-180226%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-180233%22%20slang%3D%22en-US%22%3ERe%3A%20Formulae%20do%20not%20recalculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180233%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%26nbsp%3B%20That%20was%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-180231%22%20slang%3D%22en-US%22%3ERe%3A%20Formulae%20do%20not%20recalculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180231%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Steve%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20think%20the%20%3CSTRONG%3EInspect%20Document%20%3C%2FSTRONG%3Etool%20is%20related%20to%20this.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20seems%20that%20the%20calculation%20option%20in%20your%20workbook%20is%20set%20to%20%3CSTRONG%3EManual%3C%2FSTRONG%3E%2C%20to%20change%20it%20to%20%3CSTRONG%3EAutomatic%3C%2FSTRONG%3E%20go%20to%3A%3C%2FP%3E%0A%3CP%3EFormulas%20(Ribbon%20tab)%20%26gt%3B%26gt%3B%20C%3CSPAN%3Ealculation%20%26gt%3B%26gt%3B%20Calculation%20Options%20%26gt%3B%26gt%3B%20Automatic%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI%20hope%20this%20helps%20you%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476968%22%20slang%3D%22en-US%22%3ERe%3A%20Formulae%20do%20not%20recalculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476968%22%20slang%3D%22en-US%22%3ECorrect%20answer%20-%20but%20for%20us%20novices%20-%20or%20semi-literate%20in%20Excell%3CBR%20%2F%3EClick%20on%20Formula%20Tab%20-%20Calculate%20Option%20on%20far%20right%20of%20that%20ribbon%20and%20you%20can%20change%20it%20to%20Automatic.%3CBR%20%2F%3ESomething%20strange%20is%20going%20on%20with%20recent%20updates%20to%20Excel%20360%20-%20I%20have%20multiple%20spreadsheets%20that%20had%20always%20auto%20calculated%20that%20stopped%20doing%20so.%3CBR%20%2F%3ETook%20me%20two%20days%20to%20find%20the%20way%20to%20turn%20it%20back%20on.%3CBR%20%2F%3EVERY%20frustrating.%20.%20.%20.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476969%22%20slang%3D%22en-US%22%3ERe%3A%20Formulae%20do%20not%20recalculate%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476969%22%20slang%3D%22en-US%22%3ESorry%20Haytham%20-%20Just%20saw%20the%20rest%20of%20your%20response%20-%20You%20said%20it%20right%20-%20but%20still%20confused%20as%20to%20how%20it%20changes%20to%20manual%20in%20existing%20spreadsheets.%3CBR%20%2F%3E%3CBR%20%2F%3EJim%3C%2FLINGO-BODY%3E
Steve Smallman
New Contributor

I've never had this happen before.  I change raw data in a spreadsheet and related calculated cells do not automatically recalculate.  They only recalculate after I go into each cell and then into the formula bar and hit enter.

 

The only thing I can recall that I did recently to this spreadsheet was Check for issues > Inspect workbook.  Could that have caused it?

4 Replies
Solution

Hi Steve,

 

I don't think the Inspect Document tool is related to this.

 

It seems that the calculation option in your workbook is set to Manual, to change it to Automatic go to:

Formulas (Ribbon tab) >> Calculation >> Calculation Options >> Automatic

 

I hope this helps you

Thank you!  That was it.

Correct answer - but for us novices - or semi-literate in Excell
Click on Formula Tab - Calculate Option on far right of that ribbon and you can change it to Automatic.
Something strange is going on with recent updates to Excel 360 - I have multiple spreadsheets that had always auto calculated that stopped doing so.
Took me two days to find the way to turn it back on.
VERY frustrating. . . .
Sorry Haytham - Just saw the rest of your response - You said it right - but still confused as to how it changes to manual in existing spreadsheets.

Jim
Related Conversations