Solved

Microsoft Excel 2003 - Formula result always Zero

Posted on 2011-02-11
3
651 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 96

Accepted Solution

by:
Experienced Member 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 96

Expert Comment

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
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.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

628 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