It appears you are using the built-in add-in of Solver, not the Javascript add-in for Solver. To turn the Solver add-in on or off, go to the Tools menu and choose Excel Add-ins, then check or uncheck the Solver add-in. Quing seems to think that turning the add-in off and then back on might help this issue, so please give it a try and reply with the results. I am an unpaid volunteer and do not work for Microsoft. 'Independent Advisors' work for contractors hired by Microsoft.
'Microsoft Agents' work for Microsoft Support. Hi Maria, To help understand your situation, please confirm the following information: 1.Have you referred to Steve's reply above? 2.Confirm whether it happens to some specific files(e.g.
In the Add-Ins available box, select the Solver Add-In check box, and then click OK. If Solver Add-in is not listed in the Add-Ins available box, click Browse to locate the add-in. If you get a prompt that the Solver add-in is not currently installed on your computer, click Yes in the dialog box to install it. This will open the main Excel Solver window with the parameters of the previously saved model. All you need to do is to click the Solve button to re-calculate it. Excel Solver algorithms. When defining a problem for the Excel Solver, you can choose one of the following methods in the Select a Solving Method dropdown box: GRG Nonlinear.
Files in the OneDrive for Business, files in the Dropbox, files on your computer) or all the files. 3.Did the issue happen before?
What was your previous Office version? 4.Share the detailed steps about how you reproduced the issue.
You may capture a video and share it with us via. Moreover, here is a thread about Solver for your reference which has been reported to the related team. Regards, Felix. Hi, I'm currently having several difficulties with Solver (MacOS 10.12.4,Excel 15,33), and at at least a couple seem related to what you are seeing my priorities are always finding a workaround in order to avoid getting stuck - so: Solver pop up windows (e.g.
Solver 'Weire offering Solver free for Excel 2008 as a way of re-introducing ourselves to Mac users,' said Daniel Fylstra, Frontline Systemsi President. 'We developed the very first Solver for Excel on the Mac, but for many years our product focus has been on Windows. With the Macis recent resurgence, we felt this was a good way for us to get back onto the Mac platform.'
Microsoft has that the popular Solver function in Excel 2008 had to be dropped because their implementation depended on Visual Basic for Applicatons (VBA). In June, Microsoft announced that they were woring to bring back that function. On Friday, Microsoft also announced the immediate availability of Solver in their requires a PowerPC or Intel system, Mac OS X 10.4.11 or later, and Excel 2008 12.1.2 or later.
It is a free download.