•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Cell formula calculation works automatically.
Our take
When using spreadsheet software, it's common to encounter automatic calculations that can sometimes hinder your workflow. In your case, entering a formula like +2000+500+1000+500 correctly results in a total of 4000. However, upon reopening the file, the original formula disappears, and only the calculated value is displayed, making it challenging to edit later. To address this issue, you can adjust your settings to turn off the auto-calculation feature, allowing you to retain your formulas for future edits. Thank you for reaching out!
Hi!
When I put a formula in a cell, e.g.: +2000+500+1000+500, it says value is 4000. It's OK, but when I reopen the file, the cell forget the original forumla and only shows 4000 when I want to edit it.
How can I trun off this "auto-calculation" function?
Thanks in advance!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to erase the calculation's details?!Hi, just don't know why but since the last update, everytime I calculate smthg, it automatically list every step of the calculation in the cells below. https://preview.redd.it/bpv8kr2o5awg1.png?width=379&format=png&auto=webp&s=4775f3ea05ff6dd35a733074161266ae841ac246 How to cancel this please? Checked the settings but couldn't find anything relevant. Thank you! submitted by /u/Due_Chart2778 [link] [comments]
- Need formula to be just the numberI can't seem to get the formula to go away and just be the answer. I have tried copying and pasting with special values, but that also did not work. I am new to Excel and do not fully understand it. https://preview.redd.it/nqjt1a1g5qxg1.png?width=826&format=png&auto=webp&s=5a7942502925fdfc3f189d62218a71622349e5c8 https://preview.redd.it/xht99d7i5qxg1.png?width=680&format=png&auto=webp&s=e6c363ce08480fcdaa6c96ae3f7d834ae9a2b8e2 submitted by /u/graveyard-bones [link] [comments]