Link to home
Start Free TrialLog in
Avatar of Just0610
Just0610

asked on

Excel formulas not calculating

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?
Avatar of OnALearningCurve
OnALearningCurve

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.
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]
Avatar of Just0610

ASKER

I guess the machine needed SP2 for office 2003. That seemed to fix it.
ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial