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
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