Excel Solver on Mac

Anonymous
2017-08-24T03:12:14+00:00

Hi,

I am having a strange problem when using Excel (2016) Solver on my Mac.

When Solver is invoked, I was not able to enter data (manually or via copy/paste) into the "Value of" cell, thus not being able to set the objective for my analysis. I was still able to specify the cell for which I wanted to set the "Value of" and the cells to be changed.

Could you please inform how I can fix this problem.

Thanks,

Sophie

Microsoft 365 Insider | Excel | MacOS

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 No comments
{count} votes

9 answers

Sort by: Most helpful
  1. Anonymous
    2017-09-06T22:09:55+00:00

    Jim - Please share the full version number where you experience this issue, including the part in parenthesis, such as 15.39 (170829).  Did you reproduce it in 15.37 also?

    0 comments No comments
  2. Anonymous
    2017-09-07T04:35:43+00:00

    Thanks, Jim and Steve.

    My version of Excel is 15.39 (170829).

    0 comments No comments
  3. Anonymous
    2017-09-07T17:00:39+00:00

    Please update to the latest Insider's Fast version, which was just released this morning.  I am no longer able to reproduce the problem with that version.  Please let me know what you find.

    0 comments No comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-09-09T13:16:13+00:00

    The current build number is 170905

    0 comments No comments