1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formulas are "sticking" in the cell, not calculating when entered

When I input simple formulas into cells, and hit enter, they are not calculating. When I hit enter, the full formula remains viewable in the cell, all other functions work properly, I can continue inputting and working with the spreadsheet, its not frozen per se. Is this a bug?

The only way I have found to work around this is to copy and paste formulas from other cells, but that doesn't work every time either.

I am using Windows 11 on a Thinkpad Microsoft® Excel® for Microsoft 365 MSO (Version 2602 Build 16.0.19725.20078) 64-bit - using both the online and the app version of excel.

https://preview.redd.it/kkz4xu00jhmg1.png?width=207&format=png&auto=webp&s=3a0632fcf96e8f891258a437e9e41349dc180036

submitted by /u/Top_Floor6422
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article