Re: formulas will not compute

Tools|Options|Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"phil" <phil@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:4B79CBB0-54C6-42C8-8856-B9F305C87595@xxxxxxxxxxxxxxxx
|I have a work*** 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 spread***. Now for
| some reason, when i open the spread*** 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?


.

Loading