Share via

Excel Solver Issue

Anonymous
2017-09-01T13:37:29+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-09-15T02:11:50+00:00

    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

    0 comments

18 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-09-08T16:06:21+00:00

    I know Microsoft is working on fixing some solver issues.

    If you don't mind running pre-beta software, you might give the Insider Fast build of Excel a whirl. Go to the Help menu and choose check for updates. In AutoUpdate, click the box for joining Insider, and then click the pop-up menu and choose Insider Fast.

    Caveats: Insider Fast is very early builds of Excel that aren't in general release. You'll find a new Visual Basic Editor there, and when I tried just now, I didn't get the extra blank workbook when I launched Solver. The Insider Fast builds are weekly, large downloads and are not covered by regular Microsoft support. Instead, you post to the special Insider forum here in Microsoft Community.

    0 comments
  2. Anonymous
    2017-09-09T03:52:10+00:00

    Hi Jim, thanks for offering your help! I gave it a try and the solver issue still persists, as usual, it opened a blank excel file with the name of the previous file I used Solver in, this issue does not exist if i were to reboot excel before working on another excel file.

    I do hope for MS team to get this issue rectified soon enough!

    Cheers!

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-09-16T17:15:09+00:00

    Hi

    Now that you are on an Insider build, please use the Smile button in Excel to send your report to directly to the developers.

    If you come across any new issues or have new questions, please use the special Insider Forum heading. Also be sure to include the build number you are using.

    They're actively working on Solver issues now, so get your report in as soon as you can.

    0 comments