not calculating formulas
 

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.

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

doros wrote:

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.

--

Dave Peterson

No. I have allready checked that.

"Dave Peterson" wrote:

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

doros wrote:

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.

--

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.

doros wrote:

No. I have allready checked that.

"Dave Peterson" wrote:

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

doros wrote:

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.

--

Dave Peterson


--

Dave Peterson

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

"Dave Peterson" wrote:

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.

doros wrote:

No. I have allready checked that.

"Dave Peterson" wrote:

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

doros wrote:

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.

--

Dave Peterson


--

Dave Peterson