Before it was crashing every couple of minutes. xlxs file for 20 minutes or more without it crashing. OpenSolver for Excel Proudly powered by WordPress. We currently test against Excel 2010/2013/2016 on Windows 7 and Windows 10, and Excel 2011/2016 on OS X 10.7 through 10.11.
#How to get solver on excel for macbook air for mac
With limited support for Excel for Mac 2016. Anyway, after installing the Java update, we worked on the. OpenSolver is an Excel VBA add-in that extends Excel’s built-in Solver with more powerful solvers. It downloaded with an (1) after the file name, so it seems that I had already downloaded it before when setting up High Sierra for her, but it let me install it again (or maybe I never installed it before.?). Then out of ideas about what to do, I searched for downloaded High Sierra Java from Apple's site. Thinking it was a problem with the newest version of LibreOffice and High Sierra, I removed it (and all its associated files), then installed an older version, but that had the same problem. I have entered all the constraints as instructed to (trying to only show integers) but solver doesn’t reflect the answer on the spread sheet and keeps showing decimals. If you get a prompt that the Solver add-in is not currently installed on your computer, click Yesin the dialog box to install it. No sure if this is the correct place to post this but I am having some trouble getting the solver function to work properly on my Mac. If Solver Add-inis not listed in the Add-Ins availablebox, click Browseto locate the add-in. Well, we found that it would randomly and frequently crash with spinning beach ball cursor and the only option to force quit it. In the Add-Ins availablebox, select the Solver Add-Incheck box, and then click OK.
I've been using LibreOffice for years and suggested she use it too. She has taken over some financial responsibilities for an organization and needs to update existing Microsoft Office Excel files.
My aunt has an older iMac that will only upgrade to High Sierra.