Share via

Solver in excel mac is not there in Tools>Add ins.. :( HELP

Anonymous
2016-06-12T20:06:49+00:00

Hello, Thanks for passing by..

I'd really appreciate if someone helped me with how to install solver, because it doesn't show up here.

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. Bob Jones AKA CyberTaz MVP 430.5K Reputation points
    2016-06-13T14:16:07+00:00

    Despite the fact that you selected Excel 2016 when you posted your question, the screen shot depicts Excel 2011. On the assumption that you actually are using Office 2011, the question is, what is the specific update level of your software?

    The Solver Add-in was not included with the original release of the program. It was later added by way of Service Pack 1 (14.1.0), so if SP1 has not been applied it would explain the missing .xlam file. [BTW: The current version of Office 2011 is 14.6.4]

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-06-13T03:39:28+00:00

    On the topmost menu, when I choose Tools > Excel Add-Ins, my Excel for Mac 2016 version 15.23 shows both Analysis ToolPak and Solver Add-In.

    Both appear on the Tools menu and on the far right of the Data ribbon.

    To check your version of Excel, on the topmost menu choose Excel > About Excel.

    1 person found this answer helpful.
    0 comments