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....
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
Last Comment
-Polak
ASKER CERTIFIED SOLUTION
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
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 questionExperts 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
However the behavior returns after saving, closing, and reopening the workbook.