One of my co-workers is working on a large spreadsheet with a lot of formulas. It seems that whatever new formula she puts in results in zero. I tried a brand new worksheet and the same thing happens. I have gone to Tools..Options and the Calculation tab. It is set to automatic. I even pressed <f9> and it didn't do any good. I opened the spreadsheet from another computer and didn't have this problem.