That is correct, no circular references and circular references are not allowed.

The only thing unusual about this file is that it was marked as final, then unmarked as final. Neither F9 nor turning on Iterative Calculation made the cells in question update, but double-clicking the cell and pressing Enter did.

However, you can control when and how Excel recalculates formulas.

Iteration is the repeated recalculation of a worksheet until a specific numeric condition is met.

Excel cannot automatically calculate a formula that refers to the cell — either directly or indirectly — that contains the formula. If a formula refers back to one of its own cells, you must determine how many times the formula should recalculate. However, you can control the maximum number of iterations and the amount of acceptable change.

Precision is a measure of the degree of accuracy for a calculation.

To avoid unnecessary calculations, Microsoft Excel automatically recalculates formulas only when the cells that the formula depends on have changed.

The usual answer to this question is to turn formulas to automatic. The second usual answer is that there is some macro that is affecting the Excel settings. When I put new information in Main Copy, the value on this page stayed the same.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

Usually changing the "Workbook Calculation" option (Excel 2010) solves the problem, but if it didn't, probably the workbook itself is set to manual calculation.

To change this, open the workbook, select the "Formula" tab (Alt M), then click "Calculation Options" and the select "Automatic". I think this can happen when you end up with different data types in the fields in the given range.

Excel stores and calculates with 15 significant digits of precision.

## You must have an account to comment. Please register or login here!