Adding solver to Excel

Copper Contributor

Hi,

i have a problem with adding the excel solver. Excel says: unable to access file. I checked if the file is missing but it is there (solver.xlam).

Mauro_Boraschi_0-1646492385994.png

Mauro_Boraschi_1-1646492444963.png

 

Does anyone know what I can do?

 

Thank you

 

4 Replies

@Mauro_Boraschi 

Go to Excel Options => Add-Ins and at the bottom under "Manage" select Excel Add-Ins and press "Go". There you will see if the solver add-in is activated.

 

If that doesn't help, here are some links below.

Solver Help at www.solver.com.

 

or download it again.

Microsoft Store - Solver

 

Hope I was able to help you with this information.

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE When I activate the add-on I get the screen I attached in the original message.

@Mauro_Boraschi 

That's what I could still offer, since this error is actually unknown to me.

Carry out all updates in advance (as strange as it sounds, it helped a lot, in some cases).

Then start Excel in safe mode, see if the solver opens (do not save).

Close Excel and Start it again in normal mode and test it.

 

If that doesn't help either, then here's a great one.

Downloading and Repairing SOLVER32.DLL

Standard information: This is a non-Microsoft website.

 

Thank you for your time and patience

NikolinoDE

 

Thank you for the answer Niko