Why I am getting run time error '53' file not found: solver32.dll in Excel 2016?

Anonymous
2016-07-16T21:30:56+00:00

I am running Windows 10 and have Office 2016 installed.  When I attempt to run a solver in Excel 2016 I get the following error message: 

microsoft visual basic

run time error '53'

file not found: solver32.dll

I have tried the following fixes to no avail as well: 

making the solver add in unavailable, restarting the computer, and making it available again

Changing/Repairing Office 365

Uninstalling and reinstalling Office 365

Can someone please help me fix this annoying problem?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2016-12-08T00:09:15+00:00

    Good news! We have released a couple of fixes related to this issue with the Solver32.dll file, caused by the initialization of Power Query and Power Pivot. Please update to the latest version of Office and let us know if you continue to encounter any issues.

    Freya

    Office Newsroom

    69 people found this answer helpful.
    0 comments No comments

16 additional answers

Sort by: Most helpful
  1. Anonymous
    2016-07-17T02:25:42+00:00

    Hi,

    You may try to uncheck add in and recheck it and see if it helps.

    To do that open Excel , click on file---options----add ins—at the bottom in choose “com add-inns” from the drop down and click GO---from the list of add-ins uncheck solver add-ins and recheck it.

    You may also refer to the following article which discus similar issue and check if it helps.

    http://answers.microsoft.com/en-us/office/forum/office\_2007-excel/solver32dll-is-unavailable/9dac1398-c16b-402f-a6ba-b88ed3a1512c

    I hope the above suggestion helps. If you need further assistance, get back to us and we will be glad to assist you.

    Thank you.

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2016-07-17T21:52:34+00:00

    Thanks for the reply. I tried your fix, and also reinstalled Office 365 to no avail. do you have  any additional recommendations?

    0 comments No comments
  3. Anonymous
    2016-08-15T13:15:21+00:00

    Same problem and same steps taken: Solver on/off, Office reinstallation and language change from German to English. The solver still can't find the solver32.dll file.

    Both solver files are installed in: C:\Program Files (x86)\Microsoft Office\root\Office16\Library\SOLVER

    Any further ideas to try?

    0 comments No comments
  4. Anonymous
    2016-10-11T13:47:50+00:00

    Same problem and same steps take, same results. In my case I used this summer a premium versión of the software. Since I decided to come back to my old version I having this problem

    0 comments No comments