Microsoft visual basic runtime error 53 file not found solver32 dll

• Remove From My Forums

All replies

• Hi,
  • What is the complete error message you see? Is it solver32.dll not found?
  • What is the detailed version of Excel you are using?(You can create a new workbook, click File > Account to get Office product information)
  • Are you using a 32-bit edition Excel? or 64-bit edition? (You can check it in Product information Page, click About Excel )
  • How did you add the Excel Solver add-in? Could you tell me the steps in detail?

  If solver32.dll is not found, You should confirm if there are 2 files under that folder: C:Program FilesMicrosoft OfficerootOfficeXXLibrarySOLVER or C:Program Files (x86)Microsoft OfficerootOfficeXXLibrarySOLVER

  Tip:“OfficeXX” folder — The version corresponding to the directory(the path of the library) is different : Office14 (Office 2010), Office15 (Office 2013), Office16 (Office 2016)

  

  • You can follow these steps to reload SOLVER feature:
  1.Open VBA Editor- go to Tools- References

  

  2.Then select Browse- go to C:Program Files (x86)Microsoft OfficerootOffice16LibrarySOLVER-change File type to Microsoft Excel files(*.xlsm;*.xlam..)- select SOLVER.XLAM.
  
  Now please restart Excel and confirm if it works now.
  • The problem still cannot be solved. You can update your Office to the latest version to see if it works. You can refer to

  Install Office updates for help.
  • If you are using Excel 64-bit edition, you can copy the Solver32.dll file in the
  %SystemRoot%System32 folder to see if it works.

  • Try to repair Excel
  Repairing your Office programs can resolve issues with Excel not responding, hanging or freezing by automatically repairing errors in Office files. For instructions on doing this, see

  Repair an Office application.

  If you have any question or update, please feel free to let me know.
  Best Regards,
  Herb Gu

  ---

  Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact
  tnsf@microsoft.com.

  Click
  here to learn more. Visit the dedicated
  forum to share, explore and talk to experts about Microsoft Teams

  • Proposed as answer by

    Wednesday, September 19, 2018 12:31 AM

• Unfortunately that didn’t work. 

  What is the complete error message you see? Is it solver32.dll not found?

  «Runtime error 53, file not found.» This is the complete error message.

  What is the detailed version of Excel you are using?(You can create a new workbook, click File > Account to get Office product information)

  I don’t fin Account option in as you said. I’m using Excel 2010.

  Are you using a 32-bit edition Excel? or 64-bit edition? (You can check it in Product information Page, click About Excel )

  32-bit.

  How did you add the Excel Solver add-in? Could you tell me the steps in detail?

  From Add-ins option, check the solver add-in.

• Hi Tom,
  Sorry for my delay. You can try the following methods to see if it works.
  Method1: We can try to replace the files of this add-in to try to re-enable it, because it is possible that these files are corrupted.
  Tip: Please backup your original Solver files at first. 
  If you don’t want to reinstall Office, you can try to copy the SOLVER files from other computer where SOLVER can be loaded properly, then replace these Solver files in your current computer with them. 
  How to find the Solver files?
  Click File > Options > Add-Ins to check the location of the Solver files.
   
  Default location is C:Program Files (x86)Microsoft OfficeOffice14LibrarySOLVER or
  C:Program FilesMicrosoft OfficeOffice14LibrarySOLVER (the path depends on the bit edition your Window system is).
  There are two files: SOLVER.XLAM and SOLVER32.DLL. They are the Solver files we said.
   

  Method 2: If you can’t get the Solver files from other devices, you can fix them with Excel itself.
  Close Excel, back up and then delete the folder ”SOLVER”, restart Excel. You will see the following prompt:
   
  Click Yes. Wait for installation to complete. Check if the add-in works.

  Method 3: Reinstall Office 2010
  If the issue still can’t be solved, you can uninstall Office 2010 completely with
  the easy fix tool
  and then
  Install Office 2010 again.
  If you have any question or update, please feel free to let me know.
  Best Regards,
  Herb Gu

  ---

  Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact
  tnsf@microsoft.com.

  Click
  here to learn more. Visit the dedicated
  forum to share, explore and talk to experts about Microsoft Teams

  • Proposed as answer by
    Herb GuMicrosoft contingent staff
    Thursday, September 27, 2018 1:59 AM

• Thanks for your reply, but the issue has not been resolved. I tried the suggestion but they do nothing.

• Remove From My Forums

All replies

• Are you sure that the add-in was enabled?  Check via Excel Options ->Add-Ins…

  HTH,

  Eric

• Yes, the dialog boxes shows as usual. After I press «Solve» it runs, but does not show any result. Only the error message.

• This article http://msdn.microsoft.com/en-us/library/ff837594.aspx says that there’s a 64 bit Solver included with 64 bit Excel, so your install may have deleted the Solver32.dll. 
  I’d check your add ins and see if you have the 64 bit version, disable the 32 bit, enable the 64 bit.  Just to check, do a search and see if you still have Solver32.dll somewhere on the PC.

  Cheers,

  Eric

• Thanks, but does the 64-bit solver have another name, like «solver63.dll»?

  I have 2 solver-files in «C:Program FilesMicrosoft OfficeOffice14LibrarySOLVER»

  solver32.dll

  solver.xlam

  We have 3 computers with Excel 2010 64-bit. Fresh installed. So it cannot be only my install. It worked fine in Excel 2007.

• Hi,

  The reference file has the same name of SOLVER.XALM unregard of 64-bit or 32-bit. Please check this document:

  Using the Solver VBA Functions

  However, the reference file locates on different path.

  If your computer is 64-bit and the Office is 64-bit, the file locates at:

  C:Program FilesMicrosoft OfficeOffice14LibrarySOLVERSOLVER.XLAM

  64-bit OS & 32-bit Office:

  C:Program Files (x86)Microsoft OfficeOffice14LibrarySOLVERSOLVER.XLAM

  You can try to add reference to SOLVER.XALM manually to see if it will fix the issue.

  ---

  Best Regards, Calvin Gao [MSFT]
  MSDN Community Support | Feedback to us
  Get or Request Code Sample from Microsoft
  Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  

• I checked now, and I only have one version of the file in
  C:Program FilesMicrosoft OfficeOffice14LibrarySOLVERSOLVER.XLAM, so it must be the correct version. I tried to add a reference, but it did not help.

• Did you try to add a reference in VBA or did you check it as an active add-in in Excel?

• I tried both

  Same error.

  This code fails on last line:

      SolverOk SetCell:=»$M$6″, MaxMinVal:=3, ValueOf:=22, ByChange:=»$L$6:$L$7″, _
          Engine:=1, EngineDesc:=»GRG Nonlinear»
      SolverOk SetCell:=»$M$6″, MaxMinVal:=3, ValueOf:=22, ByChange:=»$L$6:$L$7″, _
          Engine:=1, EngineDesc:=»GRG Nonlinear»
      SolverSolve

  ? Err.Description
  File not found: Solver32.dll»

• OK, I don’t have the 64 bit version so I can’t check anything.

  This article says you must have both the add-in enabled and the reference selected in the VB Editor:
  http://msdn.microsoft.com/en-us/library/ff196600.aspx  It shows you how to do it if you have what they expect are the ‘usual’ problems.  Your error indicates to me that either you
  haven’t done both, or that one of the methods (and probably the VBA reference) is still pointed to the old version.  The only thing to do is to check that you’ve got the correct reference by surfing to the dll in the folder that Calvin pointed out above.

  Other than that, I think you’ve stumped everybody.  Sorry.

  Eric

• Thanks Eric for your help

  File not found: Solver32.dll»

  Hi,

  How about the issue on your side now? I guess that the Slover32.dll corrupted in your computer. Have you check if the file “Slover32.dll” is existed
  under the subfolder of “C:Program FilesMicrosoft OfficeOffice14LibrarySOLVER”? As I delete the “Solver32.dll”, I got the same “File not fount: Solver.dll” error. See the illustration:

   

  So you can try to reinstall Excel (not whole Office) to see if the issue will be resolved.

  I look forward to hearing of you soon.

  ---

  Best Regards, Calvin Gao [MSFT]
  MSDN Community Support | Feedback to us
  Get or Request Code Sample from Microsoft
  Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  

• Sorry to bother again

  I tried to delete the solver32.* files, and did an Office 2010 repair using the built-in function in Office. The files were restored.

  But the problem prevails…

• I had the same problem, and it was caused by an add-in that somehow modified the working directory.  Try the following:

  1. Enable the VBA/Developer tab.

  2. Go into COM Add-Ins under the Developer tab.

  3. Uncheck all of the boxes.

  4. Restart Excel.

  Then plug in some values for Solver and see if it fixes your problem.

  • Proposed as answer by

    Wednesday, May 11, 2016 1:07 PM

• It did the same error for me and i copied the Solver.dll file in the %SystemRoot%System32 folder and it
  worked!

  Hope it will work for you too!

  Jo

  • Proposed as answer by
    Marc Kh
    Thursday, April 9, 2015 11:03 PM

• JoBne, thank you, your solution fixed it for me!

  Runtime error 53: solver32.dll not found. 

  Microsoft Office Excel 2013 X64 on Windows 7 x64.

• This worked for me as well. Thank you…..

• worked for me as well, thanks

  — — —
  My situation:

  Runtime error 53: solver32.dll not found.
    after adding Solver via addin checkbox and trying to run Solver from Data/Analyze/Solver

  setup:
  Office 2016 (Office 365), Windows 10

  before fix:
  C:Program Files (x86)Microsoft OfficerootOffice16LibrarySOLVER
     files:
  SOLVER.XLAM
  SOLVER32.DLL

  After fix: (I left files in above, in addition:)

  C:WindowsSystem32
     file added:
  SOLVER32.DLL

  I then successfully ran Solver

  • Proposed as answer by
    Alexander Fan
    Thursday, April 20, 2017 2:52 PM

• Worked for me as well!

  Wonder when will they fix it in an update.

• Thank you so much!  These very specific location directions helped me!

• Thanks! You save me! It also worked to office 2016!

• This one worked for me. I had Webex productivity tool in the COM ADD-Ins enabled. Once i disabled. The solver worked for me. Thanks a lot.

• So basically, what we have here is yet more incompetence shown by Microsoft developers. They’re basically programming a
  64 bit program to look in the 32 bit library (System32)!!! It would make more sense if 64 bit Excel looked in the SysWOW64 folder! But nope, we can’t have sensible programming when we’re buying from Microsoft. Unbelievable that they still
  haven’t patched this either. Microsoft needs competition. Being a monopoly has caused them to be extremely sloppy.

• Thanks JoBne, your solution fixed it for me too!

  But I make a symbolic link in command prompt.
  Same result.

  mklink “C:WindowsSysWOW64solver32.dll“ “C:Program Files (x86)Microsoft OfficerootOffice16LibrarySOLVERSOLVER32.DLL”

  • Edited by
    Pinguim Gigante
    Thursday, December 22, 2016 6:22 PM
    correction

• Thank you very much, JoBne and special thanks to Raisinasm, I was able to fix this problem on my very own (and in general I’m always drawing the «blond joker», since I am really far away from being an IT Pro). Now I am extremly
  proud on myself, though it’s just because of Raisinasm’s perfect, detailed description. Thanx again, you made my day.

  Tax

  • Edited by
    taxmaxx
    Friday, January 6, 2017 5:19 PM

• Thank you, the solution is absolutely helpful.

• I tried that but it didn’t help.

• hola, yo fui a la carpeta en archivos de programa/ microsOffice/office15/library/solver y puse el acceso directo SOLVER.XLAM en escritorio, abro este primero luego una planilla excel cualquiera y ya, tengo solver.

  saludos

• Thank you JoBne, after I tried all other solutions, yours finally fixed the problem. Thank you very much