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.

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.

GR80004

Copper Contributor

Jun 19, 2020

Rahul_Dubey

Try installing the 32bit version of Office365. The issue seems to be related to the Solver32.DLL I just encountered the same problem and installing the 32bit version resolved it

jplenz
Copper Contributor
Nov 03, 2020
GR80004 This worked for me! Try installing office 32 bit instead of 64 bit. Couldn't get 64bit to work no matter what i tried. Now 32bit is working fine