|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 29th, 2005, 10:05 AM
|
|||
|
|||
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
March 29th, 2005, 01:40 PM
|
|||
|
|||
|
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
March 30th, 2005, 12:39 PM
|
|||
|
|||
|
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
March 30th, 2005, 01:29 PM
|
|||
|
|||
|
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
April 5th, 2005, 12:29 PM
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formulas correct yet not calculating until reopening file | tennille | General Discussion | 1 | November 4th, 2004 11:22 PM |
| my excel is no longer automatically calculating formula's - any i. | Sandy | General Discussion | 1 | September 20th, 2004 06:38 PM |
| formulas appear as text in cells without calculating | drcampl | General Discussion | 2 | July 14th, 2004 03:39 PM |
Linear Mode
