Excel formulas not updating until save

Click on the Cell containing the Formula and see if the Formula is enclosed in Quotes. Note: You are allowed to use quotes inside the formulas, but not to enclose the Formula in quotes.

As you can see in the image below, Formula starting with a space before the equal sign is being treated as text by Excel. If everything about the Formula appears right and yet the Formula is not working, it is likely that the Cell containing the formula is in Text Format. Right-click on the Cell containing the Formula and click on Format Cells… option in the drop-down menu.

On the Format Cells screen, set the format to General or a particular Number Format in which you want to display the result produced by the formula and click OK. After changing the Format, click into the Formula bar and hit the Enter key on the keyboard of your computer. Hi, I hope you find my site useful!

I, like you are an enthusiast and do not make any income whatsoever from this site. It is my blog site. All posts are correct at the time of writing, I do my best to keep my site current but cannot continually check every post. If you find something that no longer works, let me know via comment or email and I will happily do my best to update it.

Systems, packages, software and repositories are constantly changing and I cannot keep up with every change or update. I recently had a client who was having an issue with excel. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.

You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Excel formulas don't update till you save. Thread starter dinesti Start date Apr 5, Joined Nov 9, Messages Is there a way to turn of what seems to be a new feature that does not show the calculation for new formulas till you save the file? To clarify, I have input data with formulas, then decided to edit some of the formulas, but the updated calculation results do not show until I save the document.

Excel Facts. Create a chart in one keystroke. Click here to reveal answer. You can change the default chart to any chart type. Joined Jun 17, Messages 7,