C
Chew
This happened to a spreadsheet that i used very often once.
A formula which has link to cell in in other sheet suddenly does not
auto-calculate after i changed the input value in other sheet. I got to
select the cell with formula and press F2 to force it update the calculated
value.
I was so surprised bcos this never happened before!
I then exit Exel and open the same spreadsheet again, that problem never
happened any more.
Im wondering why and when this happen, and have i made any "mistake" on the
value i calculated before by using that spreadsheet.
Is this so-called "transient error" in computing? I was so "lucky" to
encounter this error.
A formula which has link to cell in in other sheet suddenly does not
auto-calculate after i changed the input value in other sheet. I got to
select the cell with formula and press F2 to force it update the calculated
value.
I was so surprised bcos this never happened before!
I then exit Exel and open the same spreadsheet again, that problem never
happened any more.
Im wondering why and when this happen, and have i made any "mistake" on the
value i calculated before by using that spreadsheet.
Is this so-called "transient error" in computing? I was so "lucky" to
encounter this error.