Solved

Microsoft Excel 2003 - Formula result always Zero

Posted on 2011-02-11
3
640 Views
Last Modified: 2012-05-11
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.  

Any ideas?
0
Comment
Question by:skyriac
  • 2
3 Comments
 
LVL 92

Accepted Solution

by:
John Hurst earned 250 total points
ID: 34874693
So the issue is unique to that workstation.

(a) Do an office repair (Help or Tools menu in Excel 2003 IIRC).
(b) Better yet, do a full uninstall of Office, restart and do a full install (all components) of Office (not typical install). .

... Thinkpads_User
0
 
LVL 5

Expert Comment

by:wellous
ID: 35117694
Hi Sky,
Sometimes when i don't understand what's going on with my PC , and it starts to annoy me i do system restore ... if you don't know how , here you are :
Click on : Start >> programs >> Accessories >> System tools >> System restore.
And restore your system to an earlier date when your excel sheet was working fine .

PS: this action will not delete any data or documents from your PC even if they were created after the chosen date… so no worries ..

Hope it helps,
Brgds, Wellous
0
 
LVL 92

Expert Comment

by:John Hurst
ID: 35325410
Thank you. I was pleased to assist and hope all is well now. ... Thinkpads_User
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now