Solver Does Not Work On Excel 2016 For Mac

• Solver Does Not Working On Excel 2016 For Mac

Hi, The reference file has the same name of SOLVER.XALM unregard of 64-bit or 32-bit. Please check this document: 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 Files Microsoft Office Office14 Library SOLVER SOLVER.XLAM 64-bit OS & 32-bit Office: C: Program Files (x86) Microsoft Office Office14 Library SOLVER SOLVER.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 Please remember to mark the replies as answers if they help and unmark them if they provide no help. 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: 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.

Solver Does Not Working On Excel 2016 For Mac

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. 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 Files Microsoft Office Office14 Library SOLVER”?

Linear Programming with Excel Solver Applicable to Excel 2002-2016 (including Office 365) (Google Drive Solver Procedures are Available Separately)1. Before attempting to solve a linear programming problem with Excel, make sure that the 'Solver' add-in has been activated.

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 Please remember to mark the replies as answers if they help and unmark them if they provide no help.