[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel formulas not calculating

Posted on 2007-08-08
5
Medium Priority
?
2,377 Views
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?
0
Comment
Question by:Just0610
4 Comments
 
LVL 10

Expert Comment

by:OnALearningCurve
ID: 19655886
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.
0
 
LVL 9

Expert Comment

by:BTognietti
ID: 19656269
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]
0
 

Author Comment

by:Just0610
ID: 19657374
I guess the machine needed SP2 for office 2003. That seemed to fix it.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 20072226
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 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