Excel: Calculate Message Persists with Iteration Selected

 Last reviewed: November 30, 1994
Article ID: Q79496
Summary:

If the Iteration option is selected on a worksheet that contains circular references in Microsoft Excel for the Macintosh version 3.0, the Calculate message remains in the status bar even after the worksheet has been recalculated.

In Excel versions previous to 3.0, the Calculate message disappears when the worksheet is calculated.

More Information:

In Excel 3.0, the only way to remove the Calculate message from the Status Bar is to remove the circular references. It is possible to hide the status bar with the following procedure:

  1. From the Options menu, choose Workspace.

  2. Cancel the Status Bar selection.

In the absence of circular references, the Calculate message appears in the status bar when calculation is set to Manual and values in precedent cells are changed. The message indicates that the worksheet should be recalculated to ensure that values are accurate. In the case of a circular reference, the Calculate message is accurate because a circular reference can never be completely calculated.

Reference(s):

"Microsoft Excel User's Guide," version 3.0, pages 283-285

KBCategory: kbother
KBSubcategory:

Additional reference words: 3.00 auditor W_eXceL

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 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.