Excel Solver Add-In

%3CLINGO-SUB%20id%3D%22lingo-sub-2843311%22%20slang%3D%22en-US%22%3EExcel%20Solver%20Add-In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2843311%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20get%20the%20Solver%20Add-In%20to%20work.%20I%20activated%20it%20without%20a%20problem%20following%20the%20recommended%20steps%2C%20but%20once%20I%20try%20to%20use%20it%2C%20I%20get%20an%20error%20message%20saying%20the%20macro%20'SOLVER.XLAM!GetGroupLabel'%20could%20not%20be%20run%20and%20that%20macros%20might%20be%20disabled%20in%20the%20document.%26nbsp%3BI%20checked%20and%20made%20sure%20that%20I%20allow%20all%20macros%20in%20the%20document%2C%20but%20that%20did%20not%20solve%20it.%20Additionally%2C%20I%20get%20the%20following%20error%20message%20saying%20there%20is%20a%20compile%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ClaraHalmdie_0-1634152397506.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F317143i9C67F0E418A84B61%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ClaraHalmdie_0-1634152397506.png%22%20alt%3D%22ClaraHalmdie_0-1634152397506.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E(If%20I%20click%20on%20%22help%22%20a%20very%20generic%2C%20not%20helpful%20help%20page%20comes%20up%20so%20sadly%20that%20didn't%20get%20me%20anywhere%20either...)%3C%2FP%3E%3CP%3EI%20would%20very%20much%20appreciate%20any%20help%20with%20this%20problem!%20And%20I%20am%20happy%20to%20provide%20more%20information%20if%20needed!%3C%2FP%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3CP%3EClara%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2843311%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2843382%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%20Add-In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2843382%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1184764%22%20target%3D%22_blank%22%3E%40ClaraHalmdie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWelcome%20to%20the%20forum.%3C%2FP%3E%3CP%3EPlease%20read%20%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Foffice%2Fforum%2Foffice_2010-excel%2Fcannot-run-the-macro-solverxlammainex%2F60fe2fb4-0c90-457d-aef4-a8b3bb24aae2%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%26nbsp%3B%3C%2FA%3EMaybe%20it%20can%20help%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2862608%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%20Add-In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2862608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3BHi%2C%20thank%20you%20for%20taking%20the%20time%20to%20read%20through%20my%20question!%20I%20tried%20almost%20everything%20mentioned%20in%20that%20post%20and%20have%20not%20had%20any%20luck%20so%20far.%20I%20will%20try%20to%20uninstall%20Excel%20next%20and%20hope%20that%20will%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2887486%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Solver%20Add-In%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2887486%22%20slang%3D%22en-US%22%3EHi%20again!%20I%20have%20tried%20every%20tip%20in%20the%20thread%20you%20suggested%20including%20uninstalling%20and%20reinstalling%20Microsoft%20Office%20and%20I%20still%20get%20the%20same%20error%20messages%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EIf%20you%20can%20think%20of%20any%20other%20tip%20(or%20possibly%20a%20way%20to%20get%20through%20to%20Microsoft)%2C%20I%20would%20be%20very%2C%20very%20grateful!!%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

I am trying to get the Solver Add-In to work. I activated it without a problem following the recommended steps, but once I try to use it, I get an error message saying the macro 'SOLVER.XLAM!GetGroupLabel' could not be run and that macros might be disabled in the document. I checked and made sure that I allow all macros in the document, but that did not solve it. Additionally, I get the following error message saying there is a compile error:

 

ClaraHalmdie_0-1634152397506.png

(If I click on "help" a very generic, not helpful help page comes up so sadly that didn't get me anywhere either...)

I would very much appreciate any help with this problem! And I am happy to provide more information if needed!

Thank you so much!

Clara

 

4 Replies

@ClaraHalmdie 

Welcome to the forum.

Please read this Maybe it can help you.

@Juliano-Petrukio Hi, thank you for taking the time to read through my question! I tried almost everything mentioned in that post and have not had any luck so far. I will try to uninstall Excel next and hope that will work.

Hi again! I have tried every tip in the thread you suggested including uninstalling and reinstalling Microsoft Office and I still get the same error messages
If you can think of any other tip (or possibly a way to get through to Microsoft), I would be very, very grateful!!
The issue I think can be caused by 32bit vs 64bit incompatibility. Did you notice that when uninstalling MS office another office app came with the installation called "WPS Office"? If it is there you can uninstall it.