This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am having an issue with Solver since I upgraded from Excel 2011 to Excel 2016 for Macbooks.
I set up a problem that I want to use solver on, and I was able to successfully add Solver through the Tools menu.
I open solver (screenshot below):
Usually I am able to select cells after I open Solver but not since I installed Excel 2016. The reason you see the cells selected in the solver window in the above screenshot is because that was set up in Excel 2011. Then I thought maybe there is a compatibility issue with old Excel workbooks. So I set up a new problem in Excel 2016 and tried to use Solver, again same issue can't select cells, so I typed them up in the solver window and clicked on "Solve", and in both cases I get the following error message:
Is anybody facing a similar issue?
I really need Solver to work, and at the moment it seems the only viable option is to downgrade to Office 2011...
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.
It looks like that is how it works. You have to enter the cell reference manually.
Hi Arshad,
Actually even inputing the cells manually still results in the same error message as the one attached to my initial post..
I too am having difficult with Excel 2016 for Mac Solver. Like you I am unable to select cells inside of Solver like I could with Excel 2011 for Mac Solver. Unlike you, if I input the cells manually I am able to get a solution.
I use Solver with my work and because it does not work properly in 2016 I am unable to make the switch.
Does anyone know where we can report this problem to Microsoft so that we can get this to work properly?
Cheers,
Donald Barar
> Does anyone know where we can report this problem to Microsoft so that we can get this to work properly? <
Regarding the "where we can report this problem to Microsoft" portion of your query, in Excel for Mac 2016 click the smiley-face icon just above the far right end of the ribbon.
Did you find a solution? I also can´t select cells inside solver. Manual input works but is not a solution as i have to work on more complex models.
Cheers
O. Sarakinov