Excel 2003: 1+1=0?

  • Thread starter Thread starter nick.mucci
  • Start date Start date
N

nick.mucci

Hi,

A couple users where I work have started noticing a problem where
Excel will randomly decide to stop performing calculations.
Essentially, if you type in an expression, Excel states that it is
equal to zero. So, entering "=1+1" will result in "0", likewise,
"=375+2352" will result in "0". Even "=1/0" returns "0". It happens
in any spreadsheet, even new ones, and the time at which it occurs
does not appear to be predictable. I wasn't able to find anything
that could explain this. Has anyone here heard of this or have any
pointers on what to do? I'd appreciate it very much.

-Nick
 
It sounds very much as if the EnableCalculation property of the sheets has
been set to false. Or at least you get this behavior if it is so set.

With a workbook that has this problem open go to the VBE (Alt-F11). In the
Project window find the workbook and expand its "Microsoft Excel Objects"
node if necessary. Then click a sheet that has the calc issue. Finally,
press F4 to open the Properties window and switch EnableCalculation to True
if it's not.


--
Jim
| Hi,
|
| A couple users where I work have started noticing a problem where
| Excel will randomly decide to stop performing calculations.
| Essentially, if you type in an expression, Excel states that it is
| equal to zero. So, entering "=1+1" will result in "0", likewise,
| "=375+2352" will result in "0". Even "=1/0" returns "0". It happens
| in any spreadsheet, even new ones, and the time at which it occurs
| does not appear to be predictable. I wasn't able to find anything
| that could explain this. Has anyone here heard of this or have any
| pointers on what to do? I'd appreciate it very much.
|
| -Nick
|
 
Thanks for the tips guys, but no luck. "Automatic" was selected as
Roger suggested, and "EnableCalculation" was set to True in VBE as Jim
suggested, but all calculations randomly decided they were going to
equal zero today. Closing and reopening Excel fixes the problem. I'm
at a loss. Any other ideas?

-Nick
 
Back
Top