Solved

Microsoft Excel 2003 - Formula result always Zero

Posted on 2011-02-11
3
646 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 95

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 95

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

710 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