Excel formulas not calculating

Posted on 2007-08-08
Last Modified: 2009-01-07
I have a user that is trying to use a Ecel 2003 form but the formulas are not adding th calculations to the appropriate cells. The calculation IS set to Automatic. Any ideas why this would not work on this particular computer? The form works correctly on all other computers running the same version of Excel?
Question by:Just0610
    LVL 10

    Expert Comment

    Are the formulas being displayed as text in the cell (i.e =SUM(A1:A100))?

    If so check the formatting of the cells is not set to text.
    LVL 9

    Expert Comment

    What is in the cell where you were expecting the calculation? Is there an error?

    Is the source workbook on a network share and does the user have appropriate access rights?
    Are external links intact and updated? [Edit > Links > Update Values]

    Author Comment

    I guess the machine needed SP2 for office 2003. That seemed to fix it.
    LVL 1

    Accepted Solution

    PAQed with points refunded (250)

    EE Admin

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now