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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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
Highlighted
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.

 

 

1 Reply
Highlighted

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