If the model contains nonlinear relationships (check the model statistics in the status report), consider re-solving the model with different starting values for the adjustable cells.

If you know of a better solution than the one returned by What’s Best!, input the new adjustable cell values and check that all the constraints are satisfied and the best cell has improved. For information on the Omit feature, see the section entitled Advanced…|Omit. If you are using the Omit feature, carefully check the contents of each omitted range. Look at all of the constraints in the model to ensure that each was formulated properly, all cell references are correct, and their signs (=, and =) are correct. A warning you consider trivial may be a sign of a more serious underlying problem. Check the returned status report for any indication of a problem. Use the Warnings feature to enable all warning messages (set via Options.|General) and re-solve the model. Suggestions: The following actions may help you in checking your formulation and/or improving the solution returned by What's Best!: The model may be incorrectly formulated or, with a nonlinear model, the returned solution may be a local optimum rather than a global optimum. Problem: There is a solution that yields a better value in the best cell and satisfies all constraints. Location of the Registry Keys and Product Codes It takes very long to set cells to 'Adjustable' Some Update functionalities on the Menu, and Toolbar do not work. Menu and Toolbar/Ribbon not showing after installation. What 32-bit or 64-bit format should be installed?Įrror in Managing Temporary Files/TEMPFILE?Īfter installing, the 'About What's Best!' shows all 0 in the Library version. When using Function Support, the system seems to hang with the message 'Server Busy'. How do I fix the 'Error in returning solution in cell…' error message? How do I fix the 'Error in Auto_add: #=5: Invalid procedure or call argument' error message? How do I fix the 'Error Opening File' error message? What can I do if I receive an error message?

Where are the What’sBest! add-in files installed on my computer? How do I install What’sBest! add-in on my computer?

What are the system requirements to install What’s Best! ? There are Excel® error codes of #REF! in What’sBest! cells. When I try to close Excel®, an error appears stating, 'This workbook is currently referenced by another workbook and cannot be closed'. The solution returned from What's Best! is not optimal.Īn Excel® error appears claiming that a workbook cannot be opened under High Security Level.Īn Excel® error appears referring to 'multiple copies of WBA.XLA, WBA.XLAM'.

Excel add ins folder windows 7