Please Help! Excel Solver Ad-in Error for Excel for Microsoft 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1487379%22%20slang%3D%22en-US%22%3EPlease%20Help!%20Excel%20Solver%20Ad-in%20Error%20for%20Excel%20for%20Microsoft%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1487379%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20install%20the%20Excel%20Solver%20Ad-in%20for%20a%20class%20I%20am%20in.%20I%20have%20followed%20the%20steps%20given%20and%20played%20around%20with%20the%20macro%20settings%20and%20I%20continue%20to%20get%20the%20following%20errors%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetGroupLabel'.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20maybe%20disabled%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Compile%20Error%20hidden%20in%20the%20module%3A%20SolverCode.%3C%2FP%3E%3CP%3EThis%20error%20commonly%20occurs%20when%20the%20code%20is%20incompatible%20with%20the%20version%2C%20platform%2C%20or%20architecture%20of%20this%20application.%20Click%20%22Help%22%20for%20more%20information%20on%20how%20to%20correct%20this%20error.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20played%20around%20with%20it%20a%20great%20deal.%20If%20there%20is%20any%20advice%20you%20have%20to%20help%20me%20get%20up%20and%20running%20with%20Solver%20it%20would%20be%20greatly%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1487379%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492377%22%20slang%3D%22en-US%22%3ERe%3A%20Please%20Help!%20Excel%20Solver%20Ad-in%20Error%20for%20Excel%20for%20Microsoft%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492377%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F709422%22%20target%3D%22_blank%22%3E%40AliciaTenB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20file%20options%2C%20Select%20Addins%20in%20(Excel%20options)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SupreethGuptha_0-1593185354899.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201321iC85F5C80E3485681%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SupreethGuptha_0-1593185354899.png%22%20alt%3D%22SupreethGuptha_0-1593185354899.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E2.%20Manage%20add%20ins%2C%20click%20on%20%22Go%22%20next%20to%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.From%20add%20ins%20pop-up%2C%20select%20Browse%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SupreethGuptha_1-1593185434085.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201322iF34B264A5CB5C8B0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SupreethGuptha_1-1593185434085.png%22%20alt%3D%22SupreethGuptha_1-1593185434085.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E4.%20Copy%20the%20folder%20address%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SupreethGuptha_2-1593185480269.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201324iBB50DDBBD024F9C5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SupreethGuptha_2-1593185480269.png%22%20alt%3D%22SupreethGuptha_2-1593185480269.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E5.%20Open%20this%20folder%20directly%20from%20my%20computer%2C%20and%20save%20the%20desired%20%22add%20in%22%20in%20this%20location.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E6.%20Follow%20the%20same%20above%20steps%2C%20and%20you%20will%20be%20able%20to%20see%20the%20new%20add-in%20in%20the%20list%2C%20which%20you%20can%20select.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need to install the Excel Solver Ad-in for a class I am in. I have followed the steps given and played around with the macro settings and I continue to get the following errors:

 

"Cannot run the macro 'SOLVER.XLAM!GetGroupLabel'. The macro may not be available in this workbook or all macros maybe disabled"

 

"Compile Error hidden in the module: SolverCode.

This error commonly occurs when the code is incompatible with the version, platform, or architecture of this application. Click "Help" for more information on how to correct this error."

 

I've played around with it a great deal. If there is any advice you have to help me get up and running with Solver it would be greatly greatly appreciated.

 

4 Replies

@AliciaTenB 

 

Hi

 

Go to file options, Select Addins in (Excel options)

SupreethGuptha_0-1593185354899.png

2. Manage add ins, click on "Go" next to it

 

3.From add ins pop-up, select Browse:

SupreethGuptha_1-1593185434085.png

4. Copy the folder address

SupreethGuptha_2-1593185480269.png

 

 

5. Open this folder directly from my computer, and save the desired "add in" in this location.

 

6. Follow the same above steps, and you will be able to see the new add-in in the list, which you can select.

 

Hope this helps

 

 

@SupreethGuptha 

 

The folder is empty. Where do I find the Solver Files to put into that folder? 

 

I have the Solver Add-In available in that popup box. I just get the errors when I try to use it which I put in my original post. 

@AliciaTenB 

Hi, 

I have an ASUS laptop and came across this post [https://techcommunity.microsoft.com/t5/excel/cannot-run-the-macro-solver-xlam-getsolverlabel/m-p/853... which helps me solve the Solver error same as you describe. If you have an ASUS laptop and encounter the error, all you need to do is remove the "WPS Office" app which came pre-installed in your laptop, and the magic will happen! The Solver add-in will work all of a sudden! Hope this helps with your issue

@AliciaTenB 

 

Translated from the link: https://answers.microsoft.com/de-de/msoffice/forum/all/solver-l%C3%A4sst-sich-nicht-aktivieren/88cec...

 

Log in as an administrator on the computer

 

Uninstall the Office again, here is a tool for it:

 

https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf...

 

Deactivate your virus scanner

 

Install Office (please check whether the selection of VBA / Macro can be activated somewhere, in the past you could omit this ...)

 

If it doesn't work now, see if you can get the 32-bit version installed (it is reported that it works afterwards).

 

If it still does not work, then it may be that guidelines have been specified in the registry in the policies that prevent the execution. Then de- / installing is of no use either, the only thing that helps here is going to a professional, contacting a PC service close to you.

 

 

Hope I was able to help you.

 

 

Nikolino

I know I don't know anything (Socrates)