Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Turning off auto unhide when calculating formulas | Excel Worksheet Functions | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Formulas not calculating | Excel Worksheet Functions |