•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formulas are "sticking" in the cell, not calculating when entered
Our take
If you're experiencing issues with formulas "sticking" in cells instead of calculating upon entry, you're not alone. This problem can arise in Microsoft Excel for various reasons, even when other functions work seamlessly. It’s essential to identify whether this behavior is a bug or a settings issue. Users often find that copying and pasting formulas can serve as a temporary workaround, but this may not always resolve the problem. Let’s explore potential solutions so you can regain full functionality in your spreadsheet experience.
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel formula automatically rewriting itself??Hi all, this is a really odd problem to run into and I am unsure how to proceed from here. I am currently entering data and I have Excel performing an =SUM(B5:AC5) for my data that is being entered. Because the data entry can go pretty fast sometimes, I would keep entering data past AC5 before I realize what happened. When I look at my SUM column, Excel has flagged my =SUM(B5:AC5) formula with the error below, which is fine and whatever, but it is automatically changing my =SUM(B5:AC5) formula to =SUM(B5:AF5) or something of similar depending on what column I stopped at. Just for reference, data from AD5 to AO5 is being summed up in another column with SUM=(AD5:AO5). Formula error being flagged by Excel I have no idea why it is doing this and I tried to ignore error, but it still automatically rewriting my formula anyways! This worksheet and formula worked smoothly 4 months ago so I don't know what is going on. submitted by /u/WildKhanine [link] [comments]
- Excel keeps inserting an old formula I don't want. How do I stop this?I have a strange problem. Whenever I start typing a formula in a new cell, Excel automatically suggests and inserts an old formula that I used months ago in a completely different workbook. It happens after I type the equals sign and the first letter. For example, I want to use SUM, but Excel fills in a long SUMPRODUCT formula from an old project. I have tried clearing the recent formulas list and turning off Formula AutoComplete in Options, but the behavior still happens. Does Excel store formula history somewhere outside the current workbook? Could this be a cache issue or something related to my account syncing across workbooks? I am using Microsoft 365 on Windows 11. This does not happen on other computers, only my main machine. Any help would be great. submitted by /u/Luann97 [link] [comments]
- How to move around in formula with arrow keys on excel for macMan, I'm just starting to use excel but please help. in formula, if I command + shift + down to highlight all data and command + delete to come back to active cell, I can't move my arrow key left or right to select more data set. I have to use my cursor to do so. and if i push enter after the formula, the computation doesnt show up right away. i have to mess with the column width just to see it. Am I tripping or is this a bug? please help. submitted by /u/vlexhvnst33z [link] [comments]
- Excel inserts old unwanted formula. How to stop it?for the last few weeks, every time I'm typing a formula and use a quotation mark, excel inserts a long formula that I wrote about 3 months prior. I can't find where it is stored or why it keeps popping up. any ideas? I've even contacted our IT department to see if it's coming from OneDrive or Sharepoint and they're stumped. Any help is appreciated. submitted by /u/PsyCar [link] [comments]
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#AI formula generation techniques#modern spreadsheet innovations#machine learning in spreadsheet applications#generative AI for data analysis#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#real-time data collaboration#financial modeling with spreadsheets#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#real-time collaboration