XL97: Solver Returns Incorrect Result (221108)



The information in this article applies to:

  • Microsoft Excel 97 for Windows

This article was previously published under Q221108

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 Download Center, see the "Resolution" section of this article.

RESOLUTION

The following file is available for download from the Microsoft Download Center:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are 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
				

Modification Type:MinorLast Reviewed:9/22/2005
Keywords:kbHotfixServer kbQFE kbdownload kbbug kbfile kbfix kbGraphxLink KB221108