Solved

Microsoft Excel 2003 - Formula result always Zero

Posted on 2011-02-11
3
642 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 93

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 93

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Some time ago I was asked to create a VBA function that would calculate a check digit for an input number, using the following procedure: First, sum up all the individual digits in the number If that sum value has more than one digit, then sum up …
Outlook Free & Paid Tools
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

839 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