XL97: Solver Returns Incorrect Result

ID: Q221108

The information in this article applies to:

SYMPTOMS

When you use the Solver add-in in Microsoft Excel 97 to calculate solutions to what-if scenarios based on adjustable cells and constraint cells, the result of the calculation is incorrect and is not the same as the result obtained in Microsoft Excel 5.

Microsoft has created an update to the Solver add-in which corrects this problem. To download this file from the Microsoft Software Library, see the "Resolution" section of this article.


RESOLUTION

The following file is available for download from the Microsoft Software Library:

Solver.exe
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from Online Services


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

When you open Solver.exe, the following file is expanded: 


   Solver.xla    created 3/10/1999

Additional query words: XL97 solver error incorrect 


Keywords          : kbfile kbdta xladdins 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: June 24, 1999