not calculating formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Names and Auto-calculation 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel Calculating problem 4
Excel sometimes not Calculating??? 2
Calculating cells 1
formulas won't fill by dragging 4
how to calculate hrs flown in last one year 0
URGENT - Formulas stopped working 6

Back
Top