When I launch Solver App it quit unexpectedly and Microsoft Excel as well launch. Why?
What is solver?
—–
Javi
MacMost Q&A Forum • View All Forum Questions • Ask a Question
Solver Quit Unexpectedly
Comments: 4 Responses to “Solver Quit Unexpectedly”
Comments Closed.
If you don't know what it is, why are you launching it?
According to Microsoft Office's site, it is "a what-if analysis tool “on steroids” that you can use to find profit-maximizing or risk-minimizing solutions, by automatically adjusting multiple input cells."
So it sounds like it is part of Excel. Maybe check the docs to see more.
As far as why it is quitting, I don't know. Perhaps you are trying to run an old version? Check to make sure that your Office install is up-to-date.
Why shouldn't Javi launch it? It sits there in the launchpad for anybody to launch. Javi doesn't know what it is doesn't mean he shouldn't launch it, right? One of the ways to get to know what an app is about is to run it. Javi didn't open or try to open those system items that could be harmful if run or changed improperly. Solver's just a simple item in the launchpad, Gary... :)
Isn't it exactly the same to what you are doing Gary in the sense that you know nothing about Solver app but you are trying to answer Javi's question? :)
My reasoning is that Solver may be a part of Excel that doesn't run independently. So launching it by itself, and having it not run, may be fine. It may be something that Excel runs when needed.
If so, it shouldn't appear in Launchpad. But Launchpad is newer that even the current version of Excel, so it may not be handled correctly yet.
I did experienced Solver quit frequently. Mostly happened when there were too much data and formula were too complicated. In some cases, it was a fast return. Solver did not even try. In some cases after a long execution, it returned a not optimal solution. It must be triigered by a time out. I used R software to perform the same task. The optimal solution was different. R gave a better solution confirmed by spreadsheet. I also write Python scripts to perform regression analysis when the sample data size is too big, e.g., beyond 100K.