not calculating formulas

D

doros

in some excel sheets, after a while it stops calculating formulas. if i copy
the hole sheet and paste it into another, everything works fine.
 
D

Dave Peterson

Any chance that on the:
tools|options|Calculation tab|
calculation was set to manual?
 
D

Dave Peterson

Try selecting all the cells (ctrl-a, twice with xl2003) and then
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Maybe it'll "wake up" excel's calculation engine.
 
D

doros

I think I found the solution (infact someone else did it for me in the greek
excell forum!). Somehow it was ckecked in Tools - Options - View - Window
Options the selection "Formulas". I un-checked it and it seems fine.

Thanks,

Doros
 
Top