Solver don't work in excel 2010

Hi,

When updating from Excel 2007 to 2010 the solver don't work as wanted. Were it has worked in 2007 I now get an error message saying the problem is too large. Do anyone know why? ...and can I solve this issue in some way?

Thanks,
Martin

From Solver.com

All Solving methods are limited to 200 decision variables; the GRG Nonlinear and Evolutionary Solving methods are also limited to 100 constraints in addition to lower and upper bounds on the variables.

As far as I know you got 3 Solver models in Excel2010, the LP (linear), the GRG Nonlinear and the Evolutionary method so have you tested them all and with the same result?

If the model still works in Excel 2007 it is possible to keep the "old" 2007 Excel when upgrading to Excel 2010. You must choose "Customize" when you upgrade and then select what previous office components you wish to keep.

Alf

Hi Alf,

Thanks for your reply. Non of the 3 solver options work...
Keeping excel 2007 might be a solution but unfortunatley my companys IT department don't allow standalone solutions so I'm stuck with a standard update to Excel 2010...

all the best,
Martin

Perhaps you could try to contact the builders of Solver? Normally they are not that helpful as they have sold the model to Microsoft and consider this a Microsoft problem but one never knows.

http://www.solver.com/

Is it possible to upload you model after stripping "sensitive" information from it?

Alf

Originally Posted by Alf

Perhaps you could try to contact the builders of Solver? Normally they are not that helpful as they have sold the model to Microsoft and consider this a Microsoft problem but one never knows.

http://www.solver.com/

Is it possible to upload you model after stripping "sensitive" information from it?

Alf

Hi Alf,

Unfortunatley the file is loaded with sensitive material to the extent that it's not possible to send it even after stripping... But thanks for your intrest in this case. I will contact solver.com and give it a try.

All the best,
Martin

Ok, nothing doing. Best of luck to you in solving your problem.

Thanks for feedback and rep.

Alf