Excel Add-In not displayed in ribbon due to Group Policy setting Problem: The Excel Solver Add-in is enabled and appears to load during startup, but is not displayed/visible in the ribbon. Solution: Update the Group Policy setting titled “Disable UI extending from documents and templates” to uncheck/disable “Disallow in Excel”. SolverTable needs to “find” the Solver.xlam file for its code to work. The only time this will fail in Excel 2007 is a very unlikely situation: Solver is not loaded (there is no Solver item on the Data ribbon). The Solver.xlam file is not in its default location.

I have a file that uses Solver in xl2003 and xl2007 just fine. Now when we try and use this file in xl2010 it is failing. It is failing on line 52. Hqplayer desktop download. I know something has changed in Solver 2010 that VBA calls to it from older versions does not like.

How would I edit the following code, to work in 2003/2007 and 2010? Please advise and thanks. -R- Function CheckSolver() As Boolean 'Found solution to Solver issue online in Google search ' Peltier Technical Services, Inc., Copyright © 2007. All rights reserved.

' Returns True if Solver can be used, False if not. I belive it is not defining what 'solverProg' is correctly. It should be the version of Solver that is going to be used and giving me the MsgBox. Xl2003 = Solver.xla, xl2007 = Solver.xlam, xl2010 =???

Best selling AutoCAD replacement for the Apple Mac OS X - DWG/DXF 2D/3D - the AutoCAD alternative that costs about a fraction of AutoCAD. PDF 3D free export. ICADMac is a complete DWG CAD package with Perpetual License. Support of MAC OS X from El Capitan to the latest High Sierra. Many downloads like Icadmac may also include a crack, serial number, unlock code, cd key or keygen (key generator). If this is the case it is usually found in the full download archive itself. Many downloads like Icad Mac may also include a crack, serial number, unlock code, cd key or keygen (key generator). Icadmac keygen mac sierra 10. Apple is currently rolling out macOS Sierra, a major update to the Mac operating system. MacOS Sierra Breaks Popular Keygens, Pirate Finds Fix. This is achieved by running a key generator.

Chg'ing the line to replace the '+' with a '&' did nothing. The code posted in the beginning of the thread is the pre 2010 code, which still works fine in xl2007 and xl2003. I do understand why the same code does not work in 2010, or what needs to chg in order to execute the solver button in 2010? I ran a recorder while running solver and the code output is in the code area. It is different then any code that the other two had. How would I write a new macro that tells what version of Excel is running to include xl2010? I also included the code that determine what solver is being used.

Do I need to add something else to it to see the version of solver in 2010? Hope I am not confusing you too much.

This is not an easy fix. -R- SolverOk SetCell:='$M$17', MaxMinVal:=2, ValueOf:=0, ByChange:='$J$6:$J$16', _ Engine:=2, EngineDesc:='Simplex LP' SolverOk SetCell:='$M$17', MaxMinVal:=2, ValueOf:=0, ByChange:='$J$6:$J$16', _ Engine:=2, EngineDesc:='Simplex LP' SolverSolve Sub Axl2003_xl2007SolverMacro2() ' this will store the name of the version of solver you are using Dim solverProg As String Dim Result As Variant Application.ScreenUpdating = False On Error Resume Next ' turn on error handler 'Next line needed to deal/remove unexspected memory error. Application.Run 'Solver.xla!Auto_Open' If Err.Number 0 Then 'solver.xla error occurred, use solver.xlam instead Application.DisplayAlerts = False solverProg = 'Solver.xlam' Application.Run solverProg + '!Auto_Open' 'MsgBox 'Used Solver.xlam' If Err.Number 0 Then ' MsgBox ('Solver.xla or Solver.xlam not found. This is the code that it is skipping right over. Run.xla should fail, because it is xl2010. The If Err.Number  0 Then is setting the ver of Solver to use.xlam, but right after that code, that next If Err.Number  is executing and causing the issue.