Press F9 to do a manual recalculation.
Did that work? Then you worksheet is set to manual recal
Open Options (what version of Excel are you using?) and reset to Automatic.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"Danni" wrote in message
...
Why is that my answer to my formula will not update? It was working fine
at
first not it do not. I want to count text in each cell (eg. A5-A9). The
formula I use is =COUNTA(A5:A9). My answer will be 5. When I delete a row
the
answer do not update. Why?