Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1588679%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588679%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E%3CBR%20%2F%3EJust%20a%20question%20regarding%20excel.%20We%20have%20the%20newest%20version%20and%20at%20the%20minute%2C%20we%20have%20to%20keep%20pressing%20f9%20function%20to%20populate%20changes%20whereas%20before%20it%20used%20to%20do%20it%20on%20its%20own..%20any%20advise%20please%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1588679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1588801%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1588801%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759475%22%20target%3D%22_blank%22%3E%40grimsby228%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EActivate%20the%20Formulas%20tab%20of%20the%20ribbon.%3C%2FP%3E%0A%3CP%3EMake%20sure%20that%20Automatic%20has%20been%20selected%20in%20the%20Calculation%20Options%20dropdown.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S3469.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F212399i3CEC2813FE78CA0C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22S3469.png%22%20alt%3D%22S3469.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1589343%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589343%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20F9%20shall%20work%20independently%20of%20this%20setting.%20Ctrl%2BAlt%2BShift%2BF9%20gives%20bit%20more%2C%20but%20it%20depends.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1589708%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%20Sergei%2C%20I%20am%20aware%20of%20that%2C%20but%20the%20OP%20stated%20%22we%20have%20to%20keep%20pressing%20f9%20function%20to%20populate%20changes%22.%20I%20took%20this%20to%20mean%20that%20automatic%20recalculation%20has%20been%20turned%20off.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi

Just a question regarding excel. We have the newest version and at the minute, we have to keep pressing f9 function to populate changes whereas before it used to do it on its own.. any advise please?
3 Replies

@grimsby228 

Activate the Formulas tab of the ribbon.

Make sure that Automatic has been selected in the Calculation Options dropdown.

 

S3469.png

@Hans Vogelaar 

IMHO, F9 shall work independently of this setting. Ctrl+Alt+Shift+F9 gives bit more, but it depends.

@Sergei Baklan 

Hi Sergei, I am aware of that, but the OP stated "we have to keep pressing f9 function to populate changes". I took this to mean that automatic recalculation has been turned off.