Home

Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'.

%3CLINGO-SUB%20id%3D%22lingo-sub-220417%22%20slang%3D%22en-US%22%3ECannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-220417%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20need%20to%20use%20the%20solver%20add-in%20for%20my%20studies.%20However%2C%20Every%20time%20I%20try%20to%20use%20it%20I%20get%20an%20error%3A%20%22Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%20The%20macro%20may%20not%20be%20avaliable%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EEven%20if%26nbsp%3BI%20uninstalled%20Office%20products%20on%20my%20PC%2C%20the%20error%20was%20not%20solved.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20will%20be%20glad%20if%20you%20solve%20this%20problem.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%2C%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-220417%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254208%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254208%22%20slang%3D%22en-US%22%3E%3CP%3EHope%20that%20the%26nbsp%3Bfollowing%20link%20is%20helpful%20to%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F0a45c5a5-541f-4447-8053-eb7b4d442cfa%2Fexcel-2016-solver-error-message-windows-10%3Fforum%3Dexcel%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F0a45c5a5-541f-4447-8053-eb7b4d442cfa%2Fexcel-2016-solver-error-message-windows-10%3Fforum%3Dexcel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-254207%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-254207%22%20slang%3D%22en-US%22%3EThank%20you%20for%20trying%20to%20solve%20it%2C%20but%20it%20the%20error%20actually%20appear%20after%20add-in%20is%20enabled%20(through%20options%20like%20you%20say)%20and%20after%20you%20try%20to%20use%20it%20(press%20on%20solvers%20button)%20it%20shows%20an%20error%20%22Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%22%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253946%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253946%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20not%20used%20to%20use%20%22Solver.xlam%22%20but%20it%20is%20related%20to%20add-ins.%20You%20may%20go%20to%20Option%20--%26gt%3B%20Add-Ins%20to%20see%20if%20it%20is%20enabled%20or%20not.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-253875%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-253875%22%20slang%3D%22en-US%22%3EHas%20anyone%20helped%20to%20solve%20this%20issue%3F%3CBR%20%2F%3EMy%20exams%20are%20approaching%20and%20I%20still%20haven't%20solved%20this%20issue%2C%20have%20tried%20to%20re-install%204%20times%20already%2C%20nothing%20is%20changing.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-853155%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-853155%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20recently%20encountered%20a%20similar%20issue%20with%20Solver.%20Uninstalling%20and%20installing%20office%20365%20did%20not%20work.%20The%20issue%20I%20think%20was%20caused%20by%2032bit%20vs%2064bit%20incompatibility%20yet%20when%20I%20checked%20office%2C%20windows%2C%20and%20my%20laptop%20they%20were%20all%2064bit.%20Then%20once%2C%20when%20I%20was%20uninstalling%20MS%20office%20I%20noticed%20that%20there%20was%20another%20office%20app%20that%20came%20with%20my%20laptop%20called%20%22WPS%20Office%22%20which%20is%20freeware%20shipped%20with%20Asus.%20Since%20I%20was%20not%20using%20it%2C%20I%20decided%20to%20uninstall%20it.%20And%20voila%20that%20made%20solver%20work%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-868367%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20run%20the%20macro%20'SOLVER.XLAM!GetSolverLabel'.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-868367%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408084%22%20target%3D%22_blank%22%3E%40DavidDodd888%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%2C%20after%20unistalling%20%22WPS%20office%22%20(that%20I%20never%20installed%2C%20because%20it%20came%20with%20my%20windows)%2C%20Solver%20is%20working%20again!!!%3CBR%20%2F%3EI%20had%20installed%203%20different%20versions%20of%20office%20and%20then%20I%20decided%20to%20reset%20my%20windows.%20Nothing%20worked.%3CBR%20%2F%3EUnistalling%20WPS%20office%20is%20the%20solution%20!!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
muhammet atasever
Occasional Visitor

Hi,

 

I need to use the solver add-in for my studies. However, Every time I try to use it I get an error: "Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'. The macro may not be avaliable in this workbook or all macros may be disabled."

 

Even if I uninstalled Office products on my PC, the error was not solved.

 

I will be glad if you solve this problem.

 

Thanks,

6 Replies
Has anyone helped to solve this issue?
My exams are approaching and I still haven't solved this issue, have tried to re-install 4 times already, nothing is changing.
Highlighted

I am not used to use "Solver.xlam" but it is related to add-ins. You may go to Option --> Add-Ins to see if it is enabled or not. 

Thank you for trying to solve it, but it the error actually appear after add-in is enabled (through options like you say) and after you try to use it (press on solvers button) it shows an error "Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'. The macro may not be available in this workbook or all macros may be disabled."

I've recently encountered a similar issue with Solver. Uninstalling and installing office 365 did not work. The issue I think was caused by 32bit vs 64bit incompatibility yet when I checked office, windows, and my laptop they were all 64bit. Then once, when I was uninstalling MS office I noticed that there was another office app that came with my laptop called "WPS Office" which is freeware shipped with Asus. Since I was not using it, I decided to uninstall it. And voila that made solver work again.

@DavidDodd888 Thank you so much, after unistalling "WPS office" (that I never installed, because it came with my windows), Solver is working again!!!
I had installed 3 different versions of office and then I decided to reset my windows. Nothing worked.
Unistalling WPS office is the solution !!!!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies