Solver Faiure in Excel 2003

Does the Solver add-in work normally, not called by the macro?

No--I get the same action, even when I reduce or even eliminate all constraints. The spreadsheet on which it operates contains 32 decision variables that modify a 32 x 32 table (not an array), to produce a tabel sum, and a weighted 32 component list sum. The model represents an investment portfolio of mutual funds, the amount invested in each, the rate of return on each, and the standard deviation of each. The 32 x 32 table represents the weighted covariances of the funds to derive the portfolio standard deviation. The 32 component list sums to provide the portfolio rate of return. This model has been successful, if sometimes balky (with local optima), in the past (although at the 25 rather than 32 component level), and I don't think the fault lies in the model, but rather in a corruption of Solver.

Try renaming the solver add-in files, then run detect and repair.

 

Rename the 2 files found in the following folder

 

C:\Program Files\Microsoft Office\OFFICE11\Library\SOLVER

 

solver32.dll

solver.xla

 

Mr. Bach--I did as you suggested (in my Administrator account). The files were regenerated, but the results were unchanged. I tested within my macro because that enables me to step into Solver. The steps in Solver look like this (but without the step numbers):

 

Cell:

    

Mr. Bach--I did as you suggested (in my Administrator account). The files were regenerated, but the results were unchanged. I tested within my macro because that enables me to step into Solver. The steps in Solver look like this (but without the step numbers):

 

Cell:

     

Mr. Bach--I did as you suggested, renaming and regenerating the 2 files. The new ones did show up. This was done in the Administrator account. I tested by using the macro (and without the macro) because the macro allows me to step into Solver. The Solver dialog box showed the following steps (without the step numbers):

 

1. Cell:

        [SOLVER.XLA]Excel4Functions!A1

2. Cell

        [SOLVER.XLA]Excel4Functions!A2

            Formula:

              =ERROR(FALSE)

3. Cell:

        [SOLVER.XLA]Excel4Functions!A3

             Formula:

              =CALL(SolveDLL,0)

4. Cell:

        [SOLVER.XLA]Excel4Functions!A4

              Formula:

                 =ERROR(TRUE)

5. Cell:

        [SOLVER.XLA]Excel4Functions!A5

              Formula:

                 =IF(ISERROR(TheCall)

6. Cell:

        [SOLVER.XLA]Excel4Functions!A8

              Formula:

                  =RETURN(TheCall)

Solver then terminates. When Solver is executed without the macro, of course none of this is visible. A "Solver could not find a feasible solution" message appears on the results dialog. 

Thanks for your advisories so far--Pete Schoeffel

Pete

 

The step through does not help me. Can you post the entire procedure? Or just email me a copy of the file, if that is OK with you. Aslo, what version of Excel are you using?

 

abach@absupportweb.com