Forum Discussion

Iamojules's avatar
Iamojules
Copper Contributor
Nov 17, 2020

Solver add in issue on MAC Excel 2011

Ive been trying to activate the solver add in on the tools menu but nothing shows up in the window and it doesn't let me browse for it either.  Basically I don't have any other options as add ins and I'm not sure what to do, I can't find other way to add the solver and I really need it.

 

 

5 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Iamojules 

    As for excel for mac, my knowledge is, to put it mildly, very limited. But send you this information, it may help you.

    Or a Mac specialist will see your post again and may have a solution that can help you:).

     

    Solver on Excel 2011 for Mac

    Here are some steps to take to possibly resolve the errors you are seeing. Please try each in order, then check Solver and see if the error(s) remain.


    1. Open Excel, click Tool>Add-ins

    2. Uncheck the ‘Solver.xlam’ check box

    3. Hit ‘Select’ button and navigate to /Applications/Office 11/Office/Add ins/Solver/Solver.xlam> Select the file and hit ok/open.

    4. It will give you a prompt saying this Add-in already exists, do you want to replace it.> Say yes.

    5. Now on the Excel file try using Solver and see if you still get the same behavior.

     

    If the above steps didn’t help you re-solve the issue, I’ll suggest you apply the latest update for your Office Mac 2011.

     

    To update Office 2011:

     

    1. Open any Office application such as Word, Excel, or PowerPoint.
    2. On the top menu, go to Help > Check for Updates.
    3. Under "How would you like updates to be installed?", select Automatically Download and Install.
    4. Click Check for Updates.

    Source: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac-mso_mac2011/solver-on-excel-2011-for-mac/a707e4c0-adae-4c16-9205-4d330e23c360

     

    Load the Solver Add-in in Excel

    https://support.microsoft.com/en-us/office/load-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca?ui=en-us&rs=en-us&ad=us#OfficeVersion=macOS

     

     

    Hope I could help you at least a little.

    Thank you for your patience and time.

     

    Nikolino

    I know I don't know anything (Socrates)

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

    • voramon's avatar
      voramon
      Copper Contributor
      when use solver the windows had minimize auto
      How i can solve this issue
      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor

        voramon 

        My knowledge is limited when it comes to solvers, but...

        A little more information and additional information

        such as operating system (win. 10-win.8, win server, etc.)

        and Excel version would be beneficial for everyone :).

         

        Thank you for your understanding and patience

         

        NikolinoDE

        I know I don't know anything (Socrates)

Resources