How to evaluate formula cells after writing data in those cell

[imkhalid]

Can you please provide guidelines about how can we formulas on a sheet to be evaluated after writing data to cells, currently its getting data which was previously present their not after evaluating.?

[ddaddy]

I've noticed after writing data in cells used in a formula, I need to click into the formula and hit enter for it to calculate.

Did you find a fix for this?

[ddaddy]

It seems that cells with formula also need a value entering. So if you first add the calculated value, then add the formula the value will be displayed when you first open the spreadsheet in Excel, then if you edit any of the calculated cells it will recalculate itself.