Home

Formulas on excel not updating the imformatiom

Oscarcdl
Occasional Visitor

I got a file from a colleague with formulas on it, suddenly the formulas stop working and I need to every cell and click f2 and then enter to update the results. If I don't do that the formula is not taking the new values I wrote. Is Excel 2013

1 Reply

Change your excel calculation option to Automatic in formulas menu.

Excel Settings.png

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
W10-1903 UNC path failing 0x80070043
kurgan in Windows Insider Program on
80 Replies