O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Worksheet Calculation

Excel developers used to wear T-shirts emblazoned with the battle cry "Recalc or Die." Rest assured that no developer has ever been harmed during the creation of any version of Excel. The deceptively simple process of calculation computes all formulas and then displays the results in the cells that contain them. When you change the values in the cells to which these formulas refer, Excel updates the values of the formulas as well. This updating process is called recalculation, and it affects only those cells containing references to cells that have changed.

By default, Excel recalculates whenever you make changes to a cell. If a large number of cells must be recalculated, the words Calculating Cells and a number appear at ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required