KB: Solver Table does not work with Excel 2003

by Vinaya HS on April 2, 2006

in Technology,The SP Jain Blog

Thanks for visiting Capital Advisor. I frequently update this blog to cover various topics on personal finance such as investment strategies, financial products that you should buy and ones that you really should stay away from, financial calculators, emerging themes such as early retirement and financial independence, and much more. You can Subscribe through Email and receive new articles directly in your Inbox or you can Subscribe through the RSS Feed and receive new articles in your feed reader.

If you have installed StatPro and Solver Table from the CD that comes with the book Data Analysis & Decision Making With Microsoft Excel (2nd edition) by Albright, Winston, and Zappe (AWZ), you might experience problems when trying to run Solver Table under Microsoft Excel 2003. The Solver add-in, however, works fine. Here’s how you can fix the problem and keep Excel happy.

Step 1:

Launch Excel. Disable the existing Solver Table add-in via the Tools => Add-Ins menu. Close Excel. Clear all possible caches on your computer. Search your hard-disk for all instances of “solvertable.” Delete all traces of Solver Table you find.

Step 2:

Download FixSolverTable.zip. Unzip and run Setup_June2002.exe. Install only the Solver Table component.

Step 3:

Open Excel. Go to Tools => Add-Ins. If there is a SolverTable item in the list, just make sure it is checked. Otherwise, click on Browse to locate the SolverTable.xla file. It should be in C:\Program Files\Microsoft Office\Officexx\Library\SolverTable unless you changed the defaults in the previous step. (Do not select the other .xla files in the SolverTable folder, just SolverTable.xla.) Then you can back out of Tools => Add-Ins, and you should have a properly functioning SolverTable menu item (under the Data menu) all ready to go.

Step 4:

If Step 3 solves the problem for you, then skip this step.

Close Excel. Navigate to the folder where Solver Table is installed. Overwrite the files SolverTable.xla and SolverTable1.xla with the ones from the zip file which you downloaded in Step 2. Launch Excel. Open the file SolverTable.xla and choose to “Enable Macros.” You should have a properly functioning SolverTable menu item (under the Data menu) all ready to go. Close and re-launch Excel.

Drop me a line if this method works for you.




Thanks for reading this article. I'd love to hear your opinion. Please use the comments section below to share your thoughts. I frequently write new articles that also cover several other aspects of personal finance including credit cards, financial goals, health insurance, income tax, life insurance, mutual funds, retirement planning, and much more. You can Subscribe through Email and receive new articles directly in your Inbox or you can Subscribe through the RSS Feed and receive new articles in your feed reader.

{ 1 comment… read it below or add one }

Lindsey February 6, 2011 at 2:48 AM

THANK YOU! THANK YOU! THANK YOU!! I’ve tried everything else I could think of! You’re fix did the trick! Now I can do my homework :0)

Previous post:

Next post: