Excel Formulas Issue

%3CLINGO-SUB%20id%3D%22lingo-sub-2254556%22%20slang%3D%22en-US%22%3EExcel%20Formulas%20Issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2254556%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20enter%20a%20number%20in%20a%20cell%20that%20is%20part%20of%20a%20SUM%20formula%2C%20it%20does%20not%20change%20the%20total%20until%20I%20hit%20%22save%22.%26nbsp%3B%20I%20never%20had%20to%20do%20that%20before.%26nbsp%3B%20Anyone%20else%20having%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2254556%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

When I enter a number in a cell that is part of a SUM formula, it does not change the total until I hit "save".  I never had to do that before.  Anyone else having this problem?

2 Replies

@oberlinmd 

Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.

Yes, I found that right after I posted my question.  Thanks!