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

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

excel

Excel Online

Formulas and Functions

office 365

DavidDodd888
Sep 12, 2019
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.

Man Fai Chan

Iron Contributor

Sep 18, 2018

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.

Artur Molodov
Copper Contributor
Sep 19, 2018
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."
- Man Fai Chan
  Iron Contributor
  Sep 19, 2018
  Hope that the following link is helpful to you.
  
  https://social.technet.microsoft.com/Forums/en-US/0a45c5a5-541f-4447-8053-eb7b4d442cfa/excel-2016-solver-error-message-windows-10?forum=excel

Forum Discussion

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

Resources