my excel formulas have quit working

M

MR

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

David Billigmeier

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

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

MR

F9 did not make a difference - Each and every one of my spreadsheets has quit
working (formulas) this morning.
 
M

MR

F9 did not do the trick

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

<Tools><Options>
"Calculation" tab
Check "Automatic"
Click to expand...
 
O

Oscar of Issaquah Salmon Days Festival

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.
 
M

MR

I solved it!!! It actually was the F9 problem, but hitting F9 that particular
item. So I had to change the automatic formula update item in the tools.
Crazy...I never turned it off, but I had to change it back on each
spreadsheet. Thank You!!!
 
Top