Microsoft KB Archive/102863

Microsoft Knowledge Base

Excel: Incorrect Reference in Goal Seek Dialog Box

Last reviewed: September 12, 1996
Article ID: Q102863

The information in this article applies to:

• Microsoft Excel for Windows, versions 4.0, 4.0a
• Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS

When you use the Goal Seek command (located on the Formula menu) in Microsoft Excel, the Goal Seek Status dialog box may refer to an incorrect cell when referring to the cell that contains the formula for which you want to find a specific solution.

CAUSE

To determine the reference to the cell that contains the formula for which you want to set to a specific value, the Goal Seek command refers to the cell that was active before you chose Goal Seek from the Formula menu. However, the active cell may not contain the formula for which you are goal seeking.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel.

REFERENCES

"User's Guide 2", version 4.0, pages 78-79

KBCategory: kbprb KBSubcategory: Additional reference words: 4.00 4.00a wrong incorrectly 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: September 12, 1996 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.