Excel stopped calculating.

%3CLINGO-SUB%20id%3D%22lingo-sub-200617%22%20slang%3D%22en-US%22%3EExcel%20stopped%20calculating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200617%22%20slang%3D%22en-US%22%3E%3CP%3EAfter%20a%20mandatory%20update%20last%20week%2C%20Excel%20stopped%20calculating%20when%20the%20cell%20data%20was%20changed%2Fedited.%20On%20some%20sheets%20an%20option%20to%20hard%20calculate%20was%20offered%20in%20the%20tool%20bar%2C%20but%20not%20on%20all%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20switch%20it%20back%20to%20the%20automatic%20calculation%20if%20data%20changes%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-200617%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286751%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stopped%20calculating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286751%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20just%20encountered%20the%20same%20problem%20(after%20an%20update)%20and%20used%20the%20solution%20-%20all%20OK%20again%20after%20a%20few%20minutes%20of%20panic.%26nbsp%3B%20Thanks%20to%20Billy%20Hughes%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200622%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stopped%20calculating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200622%22%20slang%3D%22en-US%22%3EFigured%20it%20out!%20Somehow%20under%20File%2FOptions%2FFormulas%20-%20under%20Calculation%20Options%20%22Manual%22%20was%20selected%20-%20should%20be%20%22Automatic%22%20(at%20least%20for%20my%20needs)%20hope%20this%20helps!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-200621%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stopped%20calculating.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-200621%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20same%20issue%20-%20anyone%20else%3F%20any%20work-around%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

After a mandatory update last week, Excel stopped calculating when the cell data was changed/edited. On some sheets an option to hard calculate was offered in the tool bar, but not on all sheets.

 

How do I switch it back to the automatic calculation if data changes?

4 Replies

I'm having the same issue - anyone else? any work-around?

Figured it out! Somehow under File/Options/Formulas - under Calculation Options "Manual" was selected - should be "Automatic" (at least for my needs) hope this helps!!

I have just encountered the same problem (after an update) and used the solution - all OK again after a few minutes of panic.  Thanks to Billy Hughes

I have an excel file that is being used to record measurement results from an automated robot cell. There is no human interaction, but my file randomly stops calculating and running my macros. It might work for 400 parts or 4000 parts, it might stop after 10 minutes or it could run for 10 days, and there's no rhyme or reason that I can find as to why it stops auto calculating but if you press F9 (refresh calculations) it starts right back up and continues to work again (for who knows how long)

 

Does anyone have an idea why it will calculate and save hundreds of reports automatically with out a single hiccup then just stop working? The computer isn't even connected to the internet so updates shouldn't be involved and the randomness of how long it works 10min/10hr makes trouble shooting difficult

 

Thanks@Billy Hughes