Solver add in issue on MAC Excel 2011

%3CLINGO-SUB%20id%3D%22lingo-sub-1895571%22%20slang%3D%22en-US%22%3ESolver%20add%20in%20issue%20on%20MAC%20Excel%202011%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1895571%22%20slang%3D%22en-US%22%3E%3CP%3EIve%20been%20trying%20to%20activate%20the%20solver%20add%20in%20on%20the%20tools%20menu%20but%20nothing%20shows%20up%20in%20the%20window%20and%20it%20doesn't%20let%20me%20browse%20for%20it%20either.%20%26nbsp%3BBasically%20I%20don't%20have%20any%20other%20options%20as%20add%20ins%20and%20I'm%20not%20sure%20what%20to%20do%2C%20I%20can't%20find%20other%20way%20to%20add%20the%20solver%20and%20I%20really%20need%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1895571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1896983%22%20slang%3D%22de-DE%22%3ESubject%3A%20Solver%20add%20in%20issue%20on%20MAC%20Excel%202011%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1896983%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871916%22%20target%3D%22_blank%22%3E%40Iamojules%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAs%20for%20excel%20for%20mac%2C%20my%20knowledge%20is%2C%20to%20put%20it%20mildly%2C%20very%20limited.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20send%20you%20this%20information%2C%20it%20may%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EOr%20a%20Mac%20specialist%20will%20see%20your%20post%20again%20and%20may%20have%20a%20solution%20that%20can%20help%20you%3A).%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESolver%20on%20Excel%202011%20for%20Mac%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22x-hidden-focus%22%3EHere%20are%20some%20steps%20to%20take%20to%20possibly%20resolve%20the%20errors%20you%20are%20seeing.%20Please%20try%20each%20in%20order%2C%20then%20check%20Solver%20and%20see%20if%20the%20error(s)%20remain.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1.%20Open%20Excel%2C%20click%20Tool%26gt%3BAdd-ins%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2.%20Uncheck%20the%20'Solver.xlam'%20check%20box%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E3.%20Hit%20'Select'%20button%20and%20navigate%20to%20%2FApplications%2FOffice%2011%2FOffice%2FAdd%20ins%2FSolver%2FSolver.xlam%26gt%3B%20Select%20the%20file%20and%20hit%20ok%2Fopen.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E4th.%20%3CSPAN%3EIt%20will%20give%20you%20a%20prompt%20saying%20this%20add-in%20already%20exists%2C%20do%20you%20want%20to%20replace%20it.%26gt%3B%20Say%20yes.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E5.%20Now%20on%20the%20Excel%20file%20try%20using%20Solver%20and%20see%20if%20you%20still%20get%20the%20same%20behavior.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIf%20the%20above%20steps%20didn't%20help%20you%20re-solve%20the%20issue%2C%20I'll%20suggest%20you%20apply%20the%20latest%20update%20for%20your%20Office%20Mac%202011.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETo%20update%20Office%202011%3A%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3COL%3E%3CLI%3E%3CSPAN%3EOpen%20any%20Office%20application%20such%20as%20Word%2C%20Excel%2C%20or%20PowerPoint.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EOn%20the%20top%20menu%2C%20go%20to%20Help%20%26gt%3B%20Check%20for%20Updates.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EUnder%20%22How%20would%20you%20like%20updates%20to%20be%20installed%3F%22%2C%20select%20Automatically%20Download%20and%20Install.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EClick%20Check%20for%20Updates.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%3ESource%3A%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_mac-mso_mac2011%2Fsolver-on-excel-2011-for-mac%2Fa707e4c0-adae-4c16-9205-4d330e23c360%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fmsoffice_excel-mso_mac-mso_mac2011%2Fsolver-on-excel-2011-for-mac%2Fa707e4c0-adae-4c16-9205-4d330e23c360%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ELoad%20the%20Solver%20Add-in%20in%20Excel%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fload-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23OfficeVersion%3DmacOS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fload-the-solver-add-in-in-excel-612926fc-d53b-46b4-872c-e24772f078ca%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%23OfficeVersion%3DmacOS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20could%20help%20you%20at%20least%20a%20little.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20patience%20and%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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-exce...

 

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-e...

 

 

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.

when use solver the windows had minimize auto
How i can solve this issue

@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)

@NikolinoDE i use macOS i don't know how to solver this problem

Thank you for help me

@voramon 

nfortunately, I am not familiar with MAC.

The only thing I can offer you are some links from Microsoft for Mac, which might help you further.

Define and solve a problem by using Solver

 

But first, I recommend Upgrade macOS to continue receiving Microsoft 365 and Office for Mac updates.

 

More help informations on using Solver

Solver Help at www.solver.com.

 

Thank you for your understanding and patience

NikolinoDE

I know I don't know anything (Socrates)