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

Hi Brian,

Did you check the above reply? Let us know if you need further help.

Regards,

Neha

Answer 3

Hi Neha,

Thanks for getting back really quickly, I apologise for the delayed response.

I've tested out both methods and the error occurs as well for both, I've also found a pattern of recurring.

If I restart my computer and launch an Excel file (let's call it File1) and use Solver, there's no such error throughout the entire process of working on File1. However, if i close File1 after being done with it and work on another file (File2) and use Solver with File2, the error will appear with File1 as the blank excel file. 

Basically, the blank file that is opened during the error has the title of the previous excel file that I worked on. I've tried and tested this pattern and this seems to be the pattern that the error follows.

Thanks for your help!

Brian

Answer 4

Hi Brian,

I'll check this issue further on my end and will let you know when I have an update.

Meanwhile, in Excel, go to the Excel menu and choose About Excel, confirm the version and build.

Thanks,

Neha

Answer 5

Hi Neha,

I'm currently using Version 15.37 (170815)