Forum Discussion

Copper Contributor

Jul 31, 2018

Solved

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.

DavidDodd888

Brass Contributor

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.

Rahul_Dubey

Copper Contributor

May 15, 2020

Hi,
I own an Asus laptop and have been trying to use solver but I'm getting the error Cannot run the macro 'SOLVER.XLAM!MainEx' and Cannot run the macro 'SOLVER.XLAM!GetSolverLabel'. I tried uninstalling and reinstalling office 2016 and then even installed 2019 but the same error occurs. Also i don't have WPS office on my laptop. Please help as I need to work with the solver on an immediate basis.

Any help from anyone would be highly appreciated.