Problem with the solver

[Costasg]

Hello all,

I have a problem with the excel solver (excel 2007).

More specifically, when I open a new spreadsheet and try to use the solver it works fine only for the first time. After that, if I want to change for example the constraints and use the solver for a second time then it does not work. It gives the message: "error in model. please specify that all cells and constraints are valid". However, everything is correct and it should work (as it does in the first time).
This issue happens in my own pc. when I do the same thing in the university's pc, it works fine. So, maybe there is an issue with my excel.

Any suggestions?

Many thanks,

Costas

[ehabiei]

Hi,

In fact I'm facing the same problem and it made me crazy.
I searched a lot on the net, but I couldn't find any especific answer.
Even I removed the solver and reinstalled it, but no difference at the end!
Could you find any solution for that?
If so, please reply me.

Thanks,


Costas[/QUOTE]