formulas will not compute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with some simple formulas, 1 for aging and another to
compute a cell * a fixed number. one is today()-H1, the other is G4*78. The
formula works fine for existing data that is in the spreadsheet. Now for
some reason, when i open the spreadsheet and enter in a value in G4, the cell
the formula is in does not change anymore, it just stays the same. When i
copy the formula and paste it into another cell, the formula reference
updates correctly, but when i put data in the cell the formula refers to, it
does not update the value in the cell. any ideas?
 
Tools|Options|Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a worksheet with some simple formulas, 1 for aging and another to
| compute a cell * a fixed number. one is today()-H1, the other is G4*78. The
| formula works fine for existing data that is in the spreadsheet. Now for
| some reason, when i open the spreadsheet and enter in a value in G4, the cell
| the formula is in does not change anymore, it just stays the same. When i
| copy the formula and paste it into another cell, the formula reference
| updates correctly, but when i put data in the cell the formula refers to, it
| does not update the value in the cell. any ideas?
 
Back
Top