Formula results not updating

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

Hi all,
I'm having a problem with Excel 2000. Recently, when I
open a workbook that had been functioning correcting. the
formulas no longer update. What I mean is that regardless
of what is in the cells feeding the formula, the cell
containing the formula remains at the result that it
contained when the workbook opened or was last corrected
(see below). It doesn't matter how simple or complicated
the formula involved is. The only way around it,is to
double-click to get the edit window, accept formula
(unchanged). It will then update. This is necessary for
each formula and each time the result should change. If
this is not the right forum for this- please let me know
what would be more appropriate.
TIA, Jerry
 
Hi
goto 'Tools - Options - Calculate' and check if automatic
calculation is enabled
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Results of Formulas 1
Why does forumula show in cell instead of formula result? 2
Formula results display only after pressing Enter key 1
formula displays as a formula, not as its result 1
E2007 formulas display as formulas, not results 3
Cell reference in formula string displays abbreviated value 2
formula errors 2
Formulas do not update 2

Back
Top