I had the same thing happen occassionally. For instnace I entered the formula
=right(A2,4) and it stayed as that. F9 didn't help. Closing and reopening the
file either.

"MR" wrote:

F9 did not do the trick

"David Billigmeier" wrote:

Try hitting F9, do your formula's update now? If so, you have automatic
calculation turned off...

<Tools<Options
"Calculation" tab
Check "Automatic"

--
Regards,
Dave


"MR" wrote:

I use excell daily - but this morning all of my formulas, is each
spreadsheet, will not work or copy.