Avatar of -Polak
-Polak
Flag for United States of America asked on

Solver32.dll Not Found in SPECIFIC Workbook When using Solver Add In

Hi guys, everything I seem to find online seem to says that when you have this error it's the .dll's location or something similar....
Here's the thing I CAN use solver just fine if I open a blank workbook and attempt to create a simple solver.

But when I'm in a specific workbook it throws the SOLVER32.DLL not found error after it finds a solution and I click "Ok" to view the results of that solution. Any idea how or why a specific workbook would cause solver to throw that error?

I cannot share the workbook. It has data in PowerPivot, and the PowerQuery add-in installed. But this is also the case for a blank workbook....
Microsoft ExcelVB ScriptAlgorithms

Avatar of undefined
Last Comment
-Polak

8/22/2022 - Mon
-Polak

ASKER
Updated trouble shooting. If I open another workbook first, allow that workbook to load solver; then open the workbook throwing the Solver32.dll error, then close the other workbook the workbook that originally throws the error does not throw the error anymore.

However the behavior returns after saving, closing, and reopening the workbook.
ASKER CERTIFIED SOLUTION
-Polak

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy