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

Cell formula calculation works automatically.

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!

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#rows.com
#formula generator
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#cell
#formula
#calculation
#auto-calculation
#value
#edit
#file
#original formula
#reopen
#function
#trun off
#submit
#comments
#link