Excel Formula Issues
 

Recently, formulas in my excel spreadsheets fail to update unless I click on
the formula bar, and then click enter. For example, if I have a formula in a
cell that is supposed to calculate the product of values contained in two
other cells, I can change one of the the values in the other cells and the
result of the formula that calulates the product will not change. If I click
in the formula bar and hit enter then the product will change.
--
TS

Excel Formula Issues
 

Tools Options... Calculate check automatic
--
Gary''s Student - gsnu200799


"TS" wrote:

Recently, formulas in my excel spreadsheets fail to update unless I click on
the formula bar, and then click enter. For example, if I have a formula in a
cell that is supposed to calculate the product of values contained in two
other cells, I can change one of the the values in the other cells and the
result of the formula that calulates the product will not change. If I click
in the formula bar and hit enter then the product will change.
--
TS