if i have a formula in cells and i change a specific cell its not changing the cells that would be affected by it unless i click into the cell then press enter.
This has only recently happened and its happening with all my excel documents old or new formula’s
for example if i have the formula in cell A3
if i then went and changed A2’s data it would not up date cell A3 and that would stay as the previous total unless i went into the cell and pressed enter.
By: liam davies