Excel Solver Issue

Question

I use solver for a number of my courses in University and I can't stand this issue anymore.

Every when I use Excel Solver on my Mac, another excel file (that i once used solver in), opens up showing a blank white page. This blank white page doesn't affect the functionality of Solver and I can still input the necessary fields if I just drag the blank excel one side. I really don't appreciate having my screen real-estate being taken up by a blank page and I can only close it if I close the solver window. What's worse, sometimes it completely hangs my excel.

Is there anything I can do to get rid of this?

Answer 1

Hi Brain,

For this issue, we have reported it to the related team. Once there is any update, we'll get back to you. To benefit other community members who have the same issue, I'd like to share a summary.

Symptom:

When using Solver on Excel 2016 for Mac, the previously created workbook (the solver was used on that workbook)will open. Solver can work on the newly created workbook and the old workbook can't be closed or modified.

Workaround:

Quit Excel 2016 for Mac and restart it.

Assessment:

Our related team is investigating it.

Regards,

Felix

Answer 2

While it is good to share this information in the General Release build forum, there is a special Insider forum where a post like this should also be made to share with other Insiders.

If you want to alert Microsoft to any of this, use the Smile button in Excel.

Answer 3

Hi All,

On Excel 2016 for Mac, if you are not able to open the drop down list of Selecting a Solving Method in Solver add-in, this should be another issue. And it has been reported to the related team. For details, please subscribe to this thread. The workaround is to install 15.37 version.

Regards,

Felix