J
JC
You probably have the sheet set to manual calculation
mode. Press F9 and see if the values update.
If this is the case and you want to return to Automatic
Calculation mode, go to Tools>Options>Calculation and
select Automatic.
Good Luck,
Jim Carlsen
example: Cell C1 is programed =A1*B1. I change A1 and
C1 does not update unless I click on the formula bar and
press enter. This is happening throughout my
spreadsheet. It was working properly but this problem
started happening abruptly.
mode. Press F9 and see if the values update.
If this is the case and you want to return to Automatic
Calculation mode, go to Tools>Options>Calculation and
select Automatic.
Good Luck,
Jim Carlsen
dependent on, those other cells do not update. For
example: Cell C1 is programed =A1*B1. I change A1 and
C1 does not update unless I click on the formula bar and
press enter. This is happening throughout my
spreadsheet. It was working properly but this problem
started happening abruptly.