SOLVED

Formulas don't work unless click fx, then approve it by clicking OK.

%3CLINGO-SUB%20id%3D%22lingo-sub-3411912%22%20slang%3D%22en-US%22%3EFormulas%20don't%20work%20unless%20click%20fx%2C%20then%20approve%20it%20by%20clicking%20OK.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3411912%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20problems.%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20My%20formulas%20do%20not%20work%20unless%20I%20select%20fx%20then%20select%20OK%20when%20the%20formula%20is%20shown%20in%20the%20%22box%22%3C%2FP%3E%3CP%3E%26nbsp%3BThese%20formulas%20will%20not%20copy%20and%20work%20either.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20I%20have%20one%20set%20of%20work%20sheets%20that%20display%20the%20error%2C%20and%20if%20I%20select%20Error%20checking%20under%20formulas%2C%20I%20get%20the%20messages%20that%20%22The%20error%20check%20is%20complete%20for%20the%20entire%20sheet%22.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22geronime_0-1653253191573.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F374050iC85D4AE23811C9C3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22geronime_0-1653253191573.png%22%20alt%3D%22geronime_0-1653253191573.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3411912%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%3CLINGO-SUB%20id%3D%22lingo-sub-3412003%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20don't%20work%20unless%20click%20fx%2C%20then%20approve%20it%20by%20clicking%20OK.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3412003%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1397723%22%20target%3D%22_blank%22%3E%40geronime%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1.%20Make%20sure%20that%20Calculation%20Options%20on%20the%20Formulas%20tab%20of%20the%20ribbon%20is%20set%20to%20Automatic.%3C%2FP%3E%0A%3CP%3E2.%20As%20long%20as%20you%20have%20circular%20references%2C%20Excel%20will%20not%20recalculate%20many%20formulas.%3C%2FP%3E%0A%3CP%3EDoes%20the%20status%20bar%20provide%20a%20clue%3F%20Sometimes%20it%20displays%20the%20address%20of%20a%20cell%20that%20causes%20a%20circular%20reference.%20You%20can%20also%20try%20Error%20Checking%20%26gt%3B%20Circular%20References%20on%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3412034%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%20don't%20work%20unless%20click%20fx%2C%20then%20approve%20it%20by%20clicking%20OK.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3412034%22%20slang%3D%22en-US%22%3EfI%20was%20able%20to%20fix%20the%20circular%20references%2C%20but%20your%20suggestion%20to%20set%20Calculations%20Options%20to%20Automatic%20immediately%20fixed%20the%20problem.%20Mine%20had%20gotten%20set%20to%20%22Manual%22.%20I%20don't%20understand%20why%20that%20was%20the%20problem%2C%20but%20it%20is%20fixed%20now.%20Thanks%20so%20much!%3C%2FLINGO-BODY%3E
New Contributor

I have two problems. 

1. My formulas do not work unless I select fx then select OK when the formula is shown in the "box"

 These formulas will not copy and work either.

 

2. I have one set of work sheets that display the error, and if I select Error checking under formulas, I get the messages that "The error check is complete for the entire sheet".

geronime_0-1653253191573.png

 

2 Replies
best response confirmed by geronime (New Contributor)
Solution

@geronime 

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

2. As long as you have circular references, Excel will not recalculate many formulas.

Does the status bar provide a clue? Sometimes it displays the address of a cell that causes a circular reference. You can also try Error Checking > Circular References on the Formulas tab of the ribbon.

fI was able to fix the circular references, but your suggestion to set Calculations Options to Automatic immediately fixed the problem. Mine had gotten set to "Manual". I don't understand why that was the problem, but it is fixed now. Thanks so much!