2) In Excel, load SolverTable into memory. To do so, Click on the File tab, then Options, then Trust Center, then Trust Center Settings, then Trusted Locations, and then Add new location. If you want to store the files somewhere else, e.g., D:\SolverTable, you should add this folder to the trusted list. I recommend creating a SolverTable folder for this purpose under Microsoft’s Library folder, i.e., c:\Program Files\Microsoft Office\Office14\Library\SolverTable, because this folder is in Microsoft’s “trusted” list. Loading SolverTable To load SolverTable, proceed as follows: 1) If you haven’t already done so, unzip the SolverTable 2010.zip file to a folder on your hard drive. But even if Solver.xlam is not in its default location, SolverTable will still work properly, provided that Solver is loaded. The default location for Solver is C:\Program Files\Microsoft Office\Office14\Library\Solver. The latter would occur only if you purposely chose a different location for Solver when you installed Office. The only time this will fail in Excel 2007 or 2010 is a very unlikely situation: Solver is not loaded (there is no Solver item on the Data ribbon) and the Solver.xlam file is not in its default location.
SolverTable needs to “find” the Solver.xlam file for its code to work. There is only one problem you might encounter and should be aware of. These have some options I had to trap for in SolverTable – hence the 2010 version. The only difference is that Solver for Excel 2010 includes Evolutionary Solver and a MultiStart option for GRG Nonlinear. The current version of SolverTable was rewritten explicitly for Excel 2010, but it should work fine with Excel 2007. The only problem is that you have to purchase these advanced versions of Solver they do not ship with Office. This version has worked fine for just about everyone, the reason being the different API (application programming interface) used by these versions of Solver. To combat these, I rewrote the add-in for Premium Solver and Risk Solver Platform, two advanced versions of Solver, and renamed it SolverTablePremium. These problems are documented on my Web site. This caused problems (for a few users, certainly not for all users) with SolverTable for Excel 2003 and earlier, and for Excel 2007. It has always presented a challenge because it invokes Solver, and Solver has some behind-the-scene idiosyncrasies that make it difficult to program for. Versions of SolverTable I developed SolverTable in the late 1990s, and I have been enhancing and modifying it ever since. Versions of SolverTable Loading SolverTable Unloading SolverTable An example file Running SolverTable o Creating a one-way table o Creating a two-way table o Being creative Other Notes
This document explains how to use SolverTable, and it illustrates the procedure with several screen shots. That is, there must be a spreadsheet model already built, and Solver must be installed. All it requires is an existing optimization model. SolverTable is very easy to use, as I describe below. SolverTable performs sensitivity analysis for an Excel optimization model, and, in most cases, its output is more relevant and understandable than the optional sensitivity output provided by Solver itself. The results are the same for the 2003 user, it opens in read only with the X1000001 file name.Welcome to the SolverTable add-in for Excel 2010 This add-in is a natural extension to the Solver add-in developed by Frontline Systems. I’m not using any special rules however, and as a test I just created a new, basic xlsx file with one word entered in the spreadsheet. If changes are made to the file, it will need to be saved with a new filename since its read-only.” Tthe file opens in read-only mode to protect the original file. xlsx file has made use of the new multiple conditional formatting rules, you will see the following message. xlsx file In Excel 2003 once the compatibility pack is installed, you will be able to open and save the file in the new. The file is not flagged read only and file permissions are not an issue. This behavior is not happening with Word, but I’m seeing this with Excel.
An Excel 2003 user, with the 2007 compatibility pack installed, can open the file and view the contents but the file is opening in read only mode and the file name changes to something temporary like “X1000001.xls (read only)”. This is horrible if it’s by design, so please let me know if there is a fix or if this is also what others are experiencing:Īn Excel 2007 xlsx file is created.