Download & Install

Analytics is a free online magazine covering the wider world of optimisation and data analysis.

OpenSolver is updated whenever new features are added or bugs fixed. Please check out the blog page for release details. You can also use the built-in update checker to keep up-to-date with the latest release.

OpenSolver comes in two versions, a simpler “linear” version and an “advanced” version with support for more solvers. Both versions are available for Mac and Windows. On Windows, OpenSolver should work with Excel 2007 and later; we test it on 32 and 64 bit Windows in Excel 2010 and 2013. (Older versions worked with Excel 2003, but we don’t test this any more.) On Mac OS X, it should work using Excel for Mac 2011 with any version of OS X newer than 10.7.

OpenSolver Linear: This is the simpler version that solves linear models using the COIN-OR CBC optimization engine, with the option of using Gurobi if you have a license. Most people use this version.

OpenSolver Advanced: As well as the linear solvers, this version includes various non-linear solvers and support for solving models in the cloud using NEOS; more info is here. Much of this code is still new and experimental, and so may not work for you.

You can see all our downloads, including previous versions, on our Open Solver Source Forge site.

To download and use OpenSolver:

  1. Download the OpenSolver Linear zip file (either Mac or Windows, depending on the machine you are using). You can also try out our experimental Advanced release (Windows or Mac) for access to non-linear solvers.
  2. Extract the files to a convenient location. (All files and sub-folders, including OpenSolver.xlam, must stay together; please do not move any files or folders out of the unzipped OpenSolver folder.) OpenSolver on Windows may not work if installed to an unmapped directory such as \\server\myfiles\ or one that contains unicode characters.
  3. Double click on OpenSolver.xlam. There may then be a small wait as Excel checks the digital signature on the OpenSolver code.
  4. If asked in an Excel Security Notice, give Excel permissions to enable the OpenSolver macros. You can click Trust all from Publisher if you do not want to be shown the Excel Security Notice again.
  5. The OpenSolver commands will then appear under Excel’s Data tab on Windows, or in the Menu Bar on a Mac.

Note that as of October 2014, the OpenSolver code is signed by the publisher “The University of Auckland”. This makes the code more secure. However, Excel will occasionally need to check the digital signature, which can take a few seconds.

OpenSolver will be available until you quit Excel. If you wish, there  are two ways you can make OpenSolver permanently available in Excel. Either, use OpenSolver…  About OpenSolver…. and check “Load OpenSolver when Excel starts”. Alternatively, you can copy the files from the .zip into the Excel add-in directory. This is typically:

Windows XP:
C:\Documents and Settings\"user name"\Application Data\Microsoft\Addins

Windows Vista and later (7, 8, 8.1):
C:\Users\"user name"\AppData\Roaming\Microsoft\Addins

Mac OSX:
/Applications/Microsoft Office 2011/Office/Add-Ins

The Excel Solver is a product developed by Frontline Systems for Microsoft. OpenSolver has no affiliation with, nor is recommended by, Microsoft or Frontline Systems. All trademark terms are the property of their respective owners.

124 comments to Download & Install

  • james


    do you have any Installation instructions for single use?


  • sagar

    I’m having trouble running the model. It says,

    The specified solver, CBC could not be found. Make sure it is correctly installed or try another solver (at line 2810)

    Please help!

    • Andrew

      Check you have everything unzipped in the folders they came in. And make sure you have no non-American chaarcters in your path. Hope this helps, Andrew

  • cuongquoc

    em caì solver nhưng không cài dc vì nó bảo thiếu file solver.xlam là sao ạ.ai có file đấy cho e với a.thanks ạ

  • Kananura

    Thanks. It has worked


  • Kananura

    I have have tried to install the solvers studio on Window 8.1 Laptop but it does not install. below is the message I have received.

    An error occurred downloading the following resource:

    Date: 9/15/2014 1:13:16 PM

    See the setup log file located at ‘C:\Users\KEVINA~1\AppData\Local\Temp\VSD7957.tmp\install.log’ for more information.

    Let someone help me

    • Andrew

      The file vstor_redist.exe is the installer for the Visual Studio Tools for Office runtime, which is needed for SolverStudio (but not OpenSolver). What does the log file say? You may need administrator privileges to install this (although it is normally pre-installed). Andrew

  • Good morning.
    OpenSover works with MS Office 2013.
    I have a problem with a variable (44130 refObj.Text = “”) not definied.

    Thank you.

    • Andrew

      Thanks for the report. What version does About OpenSolver report you as using? And what were you doing when this error occured? Andrew

  • Alex

    How do i use open solver in a macro? is there something similar to “solver.solve” for the open solver ?

    Regards, and thanks a lot.

    BTW this tool works great!

  • Ali

    I have problem with usage DEA (in Add-Ins menu)in following message:
    There are more than 20 DMUs,
    Please get the full version of the software.
    please advise me. thanks.

  • Bob

    is there any document, user manual or something to talk more in detail about this solver (same question for solver studio)

    thank you,

  • julio

    the cbc file was not found…. that’s the error

  • Austin

    To make Open Solver always in Windows 7 with Office 2007, Excel wanted the files at


  • Dave

    When I try to install, I get the message “Object Library invalid or contains references to object definitions that could not be found”

    I tried this several times and still get the same message.

  • Asif

    Does open solver allow Data Envelopment Analysis, and measuring slack based measures of efficiency (SBM) etc. ?

  • Fernando

    hi Andrew, I installed the open solver, I can see the icons, when I enter to the specific option, they don’t work, nothink happens. I have windows 8.1

  • jacen

    Wow this tool works great. I just ran a large set of numbers and it quickly found an exact solution. Thank you. I also like that I do not have to install anything. I can just click the xlam when I need it.

  • Alessandro

    Hello everyone,
    I dowloaded open solver and install it, but it doesn’t appear in the ribbon Data.
    What can I do?

    • Andrew

      Remember, OpenSolver does not need installing unless you want it every time you open Excel. Simply double clicking OpenSolver.xlam (or OpenSolver…. you may have the .xlam extension hidden) makes it available in Excel until you quit. Andrew

  • Brian

    When I download and install opensolver on my new Win8/Office 2013 machine, it will be available and work during that excel session, but once I close excel it is gone and I have to run the install executable for it to show up again. How can I fix this?

  • Søren

    Windows 7 w. Office 2010. Go to addins in settings, in the bottom you can find an option to manage addins, including removing and adding addins.

  • Hello,

    Has the bug : Is error 1004: The specified value is out of range. (at line 23520) been fixed ?

    Thank you very much


  • Aamir khan

    Hello everyone,
    If you are having problem with solver installation, then whynot use Goal seek, which is already installed in your excel, it can be found under Data > What-if Analysis > Goal seek ( Excel-2007 method). Hope this helps :)

  • Rui Prieto

    Open Solver not appearing in the Ribbon with Office 2010 under Windows 7

    After copying OS to C:/Documents and Settings/”user name”/Application Data/Microsoft/Addins, the application did not appear;
    I moved the files to C:\Program Files (x86)\Microsoft Office\Office 14\Library\
    Right clicked the Ribbon in excel
    Opened the Add-Ins tab
    Found OpenSolver under “Inactive Application Add-Ins”
    Pressed the button “Go…”
    Checked the Add-In

  • Felix

    Hello, I have downloaded the .zip file for the installation, but it doesn’t have de OpenSolver.xlam file

  • bang

    How to install it in Apple computer (MacBook Pro), for Excel 2011?

    • admin

      We are still looking for Apple developers who are happy to take this on… A>

      • Z

        I’d like to try to implement Mac version. How do I start?

        • Andrew

          Fantastic – we have been wanting to become Mac compatible for ages! I would start by trying OpenSolver on a Mac, and seeing what bits work and what bits fail. There is Windows-specific code used to run CBC.exe, but most of the code should work. I will hunt down a copy of CBC for Macintosh; I know that it exists. Please keep in contact. Andrew

          • Nathan Gould

            Where do things stand with creating a Mac version? I’d volunteer some time to make it happen. I’m not a VBA pro but wouldn’t mind climbing a learning curve if someone can spend a few minutes coaching me.

            • Andrew

              I am hoping to receive some beta Mac code shortly from one of our users. Would you be happy to test this for us (and fix any bugs!)? Andrew

  • Kevin

    Asked by my IT guy…
    There appear to be firewall dependencies. Have the vendor provide a list of ports/IPs that are needed to be opened to allow their application to run.

    Does anybody know this?

    • admin

      OpenSolver does not make any IP connections (apart from opening OpenSolver web pages). You will need an internet connection to download it, of course. Andrew

  • me

    im sorry to be a doosh bu seriusly how do you call it open solvewr when its closed on OSX ??
    call it windows solver or somthing. ITs redundant since the only people havisn issuesd with solver , are those on a MAC!

    • admin

      Who says it is “closed” on OSX? We would love a volunteer (such as yourself) to make an OSX version… it should not be that hard as the code is in VBA, with very little of the code being Windows specific.

  • Joseph

    I, already double clicked OpenSolver.xlam but it did not appeared in the data tab. my OS is Windows 8 and i’m using excel 2010, is the OS the problem?

  • Esteban


    Is error 1004: The specified value is out of range. (at line 23520) fixed?
    Back in October it was said that this occurs because of a limitation in Excel limiting the size of the rectangles added to a sheet to highlight a cell range when showing a model. I will add fixing this to our to-do list. Thanks for the report, Andrew

    Please let me know. Thanks so much for your work,

    • admin

      It has been fixed in our beta code, but not yet released. This error does not impact models being built and solved, only how they are displayed (for really big models). Keep an eye on the website for the next release. Thanks for your interest, Andrew

  • Saravanar


    Firstly, Thanks a Ton for your help. Open Solver is an Excellent Tool.

    I’m using MS Excel 2003 & working on my office laptop. I want Open Solver to appear on my excel start-up:

    I have extracted the .zip file (Open Solver & added the contents in the following directory “D:DataBSaravanarApplication DataMicrosoftAddIns” , but still Open Solver is not appearing during excel startup.

    1. Am I missing any step here ?
    2. Am I using an advanced Open Solver Version ?
    3. Am I working in the correct folder. Because I could not see any other add-ins in the aforementioned path “D:DataBSaravanarApplication DataMicrosoftAddIns”


    • admin

      I have not used Excel 2003 for ages, sorry. However, the standard zip OpenSolver download the file OpenSolver.xlam (with a .xlam extension); such .xlam files are not recognised by Excel 2003. We no longer support Excel 2003, but if you search the OpenSolver comments for “Excel 2003″ you may get some ideas that help you get this running. Sorry I cannot be of more assistance. Cheers, Andrew

  • Santiago

    Hellow Andrew
    I have the same Error of Nick “” Microsoft Visual Basic pops up with an error which reads as follows “Compile error: Can’t find project of library.”””
    Do you have a solution for this problem?

    • admin

      This is almost certainly a problem with the RefEdit control. Please check the references using the VBA editor (Tools…. References…) to see if any are missing. If you see “Missing: Ref Edit Control”, then please try unchecking that item. You can also try repairing your Excel installation; for me this is under “Excel Options” “Resources” “run Microsoft Office Diagnostics”. Please let me know if this work. Andrew

  • Suksan

    Thanks for the great solver. I have a question that what heuristic approach you use in OpenSolver (i.e. Genetic Algorithm, Linear Programing, Ant colony or any). Also, could you please give me source code OpenSolver I try to find but I couldn’t. Thanks again

    • Andrew

      Ant colony optimisation … please no! OpenSolver uses the COIN-OR CBC linear programming solver. The source code is available… open your VBA editor to see it. Andrew

  • Thomaz

    Great software congratulations!

  • Nick

    Issue when using OpenSolver. Press the Model button and the following happens: Microsoft Visual Basic pops up with an error which reads as follows “Compile error: Can’t find project of library.”

    In the background OpenSolver has opened up and I can input the fields for objective function, however when I try entering constraints, there aren’t any symbols available.
    Selecting options, save model or close does nothing. Only way to close it is to close MVB which follows with the error: “This command will stop the debugger”.

    Moved folder to program files and nothing seems to have changed. Can open cbc which shows version, build date, etc… So don’t know what to do.

    Any help would be appreciated.

    • admin

      My guess is you have a problem with your Excel set up. Try repairing Excel and/or looking for any missing references under “Tools” “References” in the VBA editor. Hope this helps, Andrew

  • kay

    Hi I have downloaded opensolver for mac and doubled clicked the zip file and moved it into my microsoft location. but when i click opensolver.xlam nothing happens.
    When I open the normal excel only the normal solver is available.
    What do I need to do to get it working again?

  • Dmitry


    I downloaded the package and extracted the files. When I press any button on OpenSolver I received the following error: “Can’t find project or library”. What could it be?

    • admin

      I have not seen that error before. Please try moving the OpenSolver folder into another location (eg program files), and trying again. Or try repairing Excel using Excel’s built-in self repair tool. You can also check the RefEdit control is installed properly; search for RefEdit on this site for more info. Please let me know how you get on. Andrew. PS: What version of Windows and Excel are you running?

      • Dmitry

        Hi Andrew,

        I think that I solved the problem. The problem was in my VBA references. I would like to ask you, how much integer and binary variables can I use in the model?


        • admin

          Do you mind describing what you fixed in your VBA references? Others might find it useful. There is no limit on the number of variables (of any type) other than memory and your patience waiting for it to solve! Andrew

  • Jordan Dant

    I know I read a comment about this from a year ago. But I was wondering if there had been any progress on open solver for Mac. Thanks.

    • admin

      No, sorry. This is not something we’ll be doing, but we’d welcome a volunteer to undertake this work. Please contact me (email hidden; JavaScript is required) if you are interested in doing this. It should not be a big task, I hope. Andrew

  • Hari

    Although I followed all the steps to convert .xlam to .xla and used it in excel 2003 machines, I am able to install successfully (after minor problems) on a few computers but, getting a problem on a few computers.

    The problem goes like this:
    In excel 2003, I am able to add opensolver from tools–>addins. But, to run the Excel solver from VBA code, I have to add reference to open solver. But, I am not able to add reference from Tools — > References in VBA editor. As soon as I click Tools –>References, I get an error message that says Excel has encountered a problem and needs to close.

    Please help me with this.

    • admin

      This sounds like an Excel bug. I don’t have 2003 any more, sorry, so am no help. Perhaps someone else reading this can give you some ideas? Andrew

  • Harsha

    Although I followed all the steps to convert .xlam to .xla and used it in excel 2003 machines, I am able to install successfully (after minor problems) on a few computers but, getting a problem on a few computers.

    The problem goes like this:
    In excel 2003, I am able to add opensolver from tools–>addins. But, to run the Excel solver from VBA code, I have to add reference to open solver. But, I am not able to add reference from Tools — > References in VBA editor. As soon as I click Tools –>References, I get an error message that says Excel has encountered a problem and needs to close.

    Please help me with this.

  • cy

    Hi Andrew,

    Tq for reply. Build model? You mean i need to put in the data and mathematical formulation in the worksheet first? Do you have any tutorial or example of using opensolver step by step? It is Solver and opensolver is the same thing?

    • admin

      Solver and OpenSolver work similarly unless you are doing a Quick Solve, which I suspect you are not. You need to set up the model on the s/sheet first. Hope this helps, Andrew

  • cy

    Hi Andrew,

    I just download the opensolver from the zip file but i cannot open the solver model from the excel 2007. It got error message pop up “No Solver model was found on sheet Sheet1″ and “Source=OpenSolver Model Build, Errnumber=-2147220504″

  • I downloaded opensolver, clicked on model=>options and I get a Compile Error: Can’t find project or library. How do i resolve that issue?

  • Kat

    Hi, I’m being asked the password. Please advise

  • Miguel


    Tengo Office 2007 y windows xp servi pack 3, luego de seguir los pasos de instalación, y de habilitar las macros, me aparece el siguiente error en un cuadro de texto de Visual Basic:

    “La biblioteca de objetos no es valida o contiene referencias a definiciones de objetos que no se pueden encontrar”

    Me podrían ayudar a resolver este error porque directamente al aceptar el error me deriva al editor de Visual Basic y desde allí no se que hacer.

    Saludos y me gustaría mucho poder experimentar con esta herramienta.

    • admin

      Google translate says you asked:I have Office 2007 and Windows XP service pack 3, then follow the installation steps, and enable the macros, I get the following error in a text box in Visual Basic:

      “The object library is not valid or contains references to object definitions that can not be found”

      I could help resolve this error because the error directly to accept me drift to the editor of Visual Basic and from there not to do.

      Greetings and I would love to experiment with this tool.

      Please search this site for comments on RefEdit, and repairing your Excel installation. I hope this helps, Andrew

  • PJ

    I have a model that does production planning one year at a time for five years. I set up the problem in OpenSolver for the first planning year. How do I change the contraints/variables/goal for the next four years using VBA without setting up the problem for each single year every time I do the production planning? Thanks.

    • admin

      I would not use VBA for this, but instead have a formula on the spreadsheet for each constraint right hand side (RHS) that looks up the required RHS value for the user-selected year. You can do the same for the constraint coefficients if these change. If you want to use VBA, then I’d do the same thing, but use VBA to step thru each year in succession and remember the results; I did exactly this for the first ever OpenSolver project. Hope this helps, Andrew

  • Josep Riverola

    1) I need to solve an old ILP that has the decision variables split acros many ranges (for usability reasons). I run Open Solver on Excel 2003. I does not allow the split ranges. Variables should be in a unique range. Any way out of this?
    2) I have to always go through the xlma start, because, in spite of having all distribution files in the xcell add-in directory. Whe I start Xcell without clicking xlma nothing happens.
    Is all this the result of running it under Xcel2003?
    Very good work. Thanks a lot!


    • admin

      Josep: 1/ I don’t have Excel 2003, but I cannot see why it won’t allow split ranges. However, you can instead create a single range that contains all your decision variables, and then link the ‘real’ decision variables back to these new ones using formulae in the real decision variables cells. 2/ Under the About OpenSolver, you can configure OpenSolver to automatically load at startup; why don’t you try this? Let me know how it goes. Andrew

  • krishna

    i have just installed opensolver19 with excel 2007(64 bit). How to start working . Plz help me

    • admin

      Krishna: I suggest you find a tutorial on using the standard Excel Solver – OpenSolver provides equivalent functionality for LP/IP models. Andrew

  • Christos

    I have the same problem with the guy above:

    “Compile error:
    The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PrtSafe attribute.”

    Win 7 with MS office 2010 64bit.
    Can you help me, too?
    Thank you.

  • alasdair

    The installation instructions refer to the Excel add-in directoryand note that this is typically: C:Documents and Settings”user name”Application DataMicrosoftAddins.

    I have just been upgraded to Windows7 and Office 2010 for which there is no such directory. For an simple user :-), can you advise the appropriate directory for OpenSolver?



    • admin

      I don’t have Windows 7, so cannot help, sorry. But you can alternatively use the About OpenSolver menu within OpenSolver to configure OpenSolver to load automatically from its current location. Hope this helps, Andrew

      • alasdair

        I have since found that the answer to my question is simple. With Office 2010 the addins can be placed anywhere on the pc. After Excel is opened, go File -> Options -> Addins -> Browse and then select the folder and addin required.

  • Rutger Tjallema

    Dear Andrew,

    I’ve used open solver many times with excel 2007, and never experienced any problems. Last week I updated to excel 2010 (64 bit) and – as I just found out – to VBA7. Unfortunately, OpenSolver doesn’t start at my laptop (windows 7 ultimate, 64 bit). When I open OpenSolver.xlam, I get the following message:

    Compile error:
    The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PrtSafe attribute.

    I’ve spend a whole day on the internet to find a solution for this problem, but unfortunately I didn’t found one. I did find some information at this website (, concerning the update to office 64bit and VBA7 and I’ve downloaded this file: But this did’t solve my problem and I don’t know what to do next. I’ve read your site that OpenSolver is compatibele with Office 2010 64bit, so hopefully you are familiar with my problem and do you know how I can make OpenSolver work at my system.

    Thanks in advance for your reaction!

  • P J Perera

    Thanks for the tips. I managed to get it going without a workaround. With Excel 2003, you need a .xla or .xls addin to reference OpenSolver from another workbook (just like the way you reference normal Solver). Renaming the .xlam addin to .xla or .xls wont work (msg “The file is not in a recognisable format”). The trick is to save the .xlam addin as a .xls workbook (by setting the “IsAddin” to False) and re-saving the .xls workbook as a .xla addin (by setting the “IsAddin” to True). Now I have a OpenSolver.xla addin which works perfectly with Excel 2003.

    Might be an idea to include this .xla addin in your distribution pack for Excel 2003 users (there is still a lot of them around). I can email it to you if you dont have Excel 2003 to generate it.

    Thanks again for a wonderful product !!!

    • Harsha

      Please send me the OpenSolver.xla file. I tried following the above steps, but, I could not get the .xla file from the .xls file.

      Thank You!!!

    • nino65

      Same as Harsha, I have excel 2003 and cannot open xlam (msg “The file is not in a recognisable format”).

      Please, post the xla version for 2003

      thanks a lot

  • P J Perera

    Downloaded OpenSolver and tried to use with Excel 2003. Good news and bad news.

    The good news is:
    Double click on OpenSolver.xlam – opens Excel (after a file conversion process)
    Opened workbook with solver problem and loaded problem on the standard Excel solver
    Inserted a sub with command “RunOpenSolver False” in the OpenSolver.xlam “OpenSolverMain” module and executed the sub
    OpenSolver works fine and I get the same result as the standard Excel solver in less than HALF THE TIME. Beautiful!!

    Now the bad news:
    I cannot create a reference to OpenSolver.xlam in my VBA project. When I try it, it looks for a .xla file and renaming the .xlam file to a .xla file wont work either
    Because of this, I cannot run OpenSolver from my VBA project code.

    Any solution or a workaround?

    • admin

      It is a long time since I have used Excel 2003! From memory, the .xlam extension is new, and so OpenSolver will need to be renamed with a .xls (or .xla) extension. (I’m not sure why you say .xla will not work?) You may wish to go with the .xls extension, and simply add your VBA code into OpenSolver (which is really just a workbook with some VBA code). In this case, you may want to open OpenSolver, open VBA, and set the “IsAddin” setting to false for OpenSolver’s “ThisWorkbook” so the worksheet will open normally. Hope this helps, Andrew

  • Ben

    Do you have a version for Microsoft office for Mac users or does this work for Macs as well?

    • admin

      Not yet. However, it should not be too hard. The OpenSolver code needs to be tweaked to replace the Windows-specific code to run CBC with similar Mac code, and a Mac version of CBC needs to be compiled (or created – does it exist?). Are you perhaps keen to look into this? Andrew

  • Hal

    Where is the source code located?

    • admin

      VBA projects have the source embedded in the Excel extension; open OpenSolver and then press ALT-F11 to open up the Visual Basic for Applications environment.

  • Paul

    I created a new Add-In for use with Excel 2000-2003 including a menu duplicating that shown for the Excel 2007 and up ribbon. I would like to send the new XLA file to you so it can be made available to your users. Please contact me via email and I’ll send it to you.

    Thank you for the excellent work!


    • admin

      Paul: That’s a great contribution; thanks. Let’s chat over email. Andrew

      • Thomas

        I am looking for the xla-file for Excel 2000-2003. Can I find it on this page?
        / Thomas

        • admin

          Thomas: Paul’s work (below) is not yet finished, and so OpenSolver does not (yet) exist in an Excel 2000 or 2003 compatible version. Note that you can call OpenSolver from VBA even in Excel 2000 and 2003; it is just the menu interface that needs to be built. Hope this helps. Andrew


      Hi, I would very much to have the 2003 plug-in, let me know what I have to do.

      • admin

        Giovanni, The current OpenSolver code should work fine as it is under Excel 2003, but it does not have any user interface. If you like to write VBA code to create and add a new Excel 2003 menu for OpenSolver, we would love to include it in the distribution. Andrew. PS: I will also email Paul again to see if he’s ready to release his code.

  • MBA Student

    Can you please provide steps how to use the open Solver in Excel 2003. I see a note about being able to call it directly from VBA. Can you please provide the steps how to do that.


    • admin

      We have never run OpenSolver under Excel 2003. However, calling ‘RunOpenSolver false’ from VBA will solve your current problem. Hope this helps. Andrew

  • Max


    Does it work with Excel 2003 at all? I don’t see any trace of the presumably installed OpenSolver.


    • admin

      There is no user interface written for Excel 2003. However, it should work if you call it directly from VBA. Alternatively, we would welcome you writing Excel 2003 menu code….

  • Wayne

    I’m a Mac user who is helping my wife who is a PC user. Two questions:

    1. It does not look like you need any kind of Administrator privileges to install OpenSolver, even to make it “Always Available”. Is this correct?

    2. The documentation says, under Using OpenSolver, that you need to create your model in Solver and use Solve to save it. I assume this will work even when your model far exceeds the limitations of the bundled Solver, correct? In my case, I have created a scheduling model that runs extremely fast in glpsol, and which is way too large for free Solver.

    • admin

      Thanks for your interest. To answer your questions:
      1. OpenSolver works fine for us without administrator access on Vista.
      2. Yes, Solver (at least our version in Excel 2007) can build models larger than it can solve.

      Hope this helps. I would be interested to hear how OpenSolver works on your scheduling model. Our focus has also been on scheduling; we developed OpenSolver to solve big set partitioning models for staff scheduling.


Leave a Reply





You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">