Excel: Iterative Calc Returns Unexpected Value to Dependent WS

 Last reviewed: November 29, 1994
Article ID: Q52165
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

If a Microsoft Excel worksheet is linked to another worksheet whose values are obtained through iteration, the values on the dependent sheet may not be the same as those on the independent sheet.

MORE INFORMATION

The following is an example:

  1. Cell A1 on Worksheet 1 is linked to cell B1 on Worksheet 2.

  2. Cell B1 on Worksheet 2 contains a formula such as "=B1+2", where the value is calculated using iteration.

  3. After calculation (iterating 10 times), cell B1 on Worksheet 2 contains the value 20.

  4. Cell A1 on Worksheet 1 now contains the value 18.

This is inherent in the use of iteration. When using iteration, Excel calculates each cell the defined number of times. In this example, cell A1 on Worksheet 1 is calculated before cell B1 on Worksheet 2; therefore, when the calculation is finished, cell A1 on Worksheet 1 will be one iteration behind.

KBCategory: kbusage
KBSubcategory:

Additional words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2
2.20 3.0 3.00 4.0 4.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.