#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 1+1=0??

In my old excel files (same Excel version 2003), all the calculations returns
0.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 1+1=0??

It was checked to automatic, moreover I tried to change to manual then to
automatic again. Saved and closed. When I open all formulas started to work.
Has no sense, but it worked.
Thank you.

"David Biddulph" wrote:

Have you checked that Tools/ Options/ Calculation is set to automatic, not
manual?
--
David Biddulph

"Nuno Guerra" wrote in message
...
In my old excel files (same Excel version 2003), all the calculations
returns
0.
If I try in a new cell this formula: =1+1 it returns 0.
All my formula calculations, SUM's, AVERAGE's had stoped running.

But if I open a new excel file all works fine.

Any help?
Thank you.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"