| 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 | |||
Linear Mode
