calculate not working

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

I'm having the same problem as Tony. My formulas are suddenly not working.
I've turned calculate auto and manual. tried saving, closing & reopening
file & still the =sum(...) formulas aren't working.
 
Perhaps the formula got entered as text? Check the formatting of the cell,
make sure it is set to something other than text, then enter cell (press F2)
and re-confirm (press enter).
 
The formula and cells are all number format. I've also tried copying and
pasting into a new workbook & still not working.
 
Can you post the formula here??

Janet said:
The formula and cells are all number format. I've also tried copying and
pasting into a new workbook & still not working.
Click to expand...
 
Formatting changes the display, not the underlying value. In particular, it
will not turn text into a number, so you not have ruled out Luke's
suggestion, though a different explanation seems more likely to me.

Can you be more specific when you say that "formulas aren't working"? Are
they displaying the formula itself, or an old result that does not update
properly when cells are changed that are used in the formula?

If formula cells display the formula itself instead of the result, what
happens if you select multiple cells that contain at least one such formula,
select empty cells, and Paste Special|Values (under the Edit menu in pre-2007
versions [try Help if you have 2007]). If you get the result(s) instead of
the formula(s) in the pasted cells, then you have probably accidentally
placed Excel into Formula Auditing mode. In pre-2007 versions either
'Tools|Formula Auditing|Formula Auditing Mode' or
CTRL + ` (grave accent) will toggle the auditing mode on or off (CTRL + `
may still work in 2007, but I have no way to verify).

Jerry
 
Back
Top