Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Calculation not working on sheet

Posted on 2011-04-27
Medium Priority
Last Modified: 2012-05-11
excel 2003

I have calculations not working all of a sudden on my worksheet.

simple stuff   =d13/d22*100        <--------- E14

If I change the value in either D13 OR D22   THE E14 DOES NOT RE-CALCULATE

Question by:Fordraiders
LVL 81

Accepted Solution

zorvek (Kevin Jones) earned 668 total points
ID: 35478716
If worksheet cells do not seem to be calculating when changing worksheet cell values or copying cells containing formulas then workbook or worksheet calculation is turned off. To turn on automatic calculation choose the menu command Tools->Options, navigate to the Calculation tab, select Automatic, and click OK. Note that in some cases manual calculation may make more sense such as when there are many calculations, complex calculations, or many UDF references which cause every calculation to take more than a second or two.

Note that a workbook can be manually calculated at any time by pressing F9.

LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 668 total points
ID: 35478718
Check if recalculation option is set to automatic in excel options
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35478722
Also, might you have set the format of those cells to Text?

LVL 23

Assisted Solution

by:Brian Gee
Brian Gee earned 664 total points
ID: 35478726
Check this setting real quick:

Tools > Options > Calculation tab > make sure that Automatic is selected in the Calculation section.

Author Closing Comment

ID: 35478775

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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…

564 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