C
cerpintax
I don’t know if anyone can help me but this problem is frustrating me.
I will try to explain as best I can. When I have a column of data, say
reference
A1 to A9 with a formula beneath it in A10 being that the formula is
=SUM(A1:A9) when I update any of the data in A1 to A9 the figure in A10
does not update. The only way to get it to update is to click in A10
where the formula is and then click in the formula bar and press enter;
the formula seems to recalculate after this and it works or you need to
save it and it works. It should work right after any change in the
data being added, I don't know what is happening or has happened but
any solution to this problem would be much appreciated.
Thanks:
I will try to explain as best I can. When I have a column of data, say
reference
A1 to A9 with a formula beneath it in A10 being that the formula is
=SUM(A1:A9) when I update any of the data in A1 to A9 the figure in A10
does not update. The only way to get it to update is to click in A10
where the formula is and then click in the formula bar and press enter;
the formula seems to recalculate after this and it works or you need to
save it and it works. It should work right after any change in the
data being added, I don't know what is happening or has happened but
any solution to this problem would be much appreciated.
Thanks: