Hi ppl, I am new to this forum, and I was hoping some Excel pro could help me with a problem using solver:

Basically I am using the SAME data set and the SAME objective cell and SAME constraints, but yet I can get HUGELY DIFFERENT results each time. Sometimes I get the message "objective cell values do not converge", other times I just get a stupid result, and sometimes I get a realistic result.

I even have two sheets with almost identical numbers, and identical formulas, which give me vbery different objective cell value results using solver.

I know the formulas are fine becaus eI have recieved the the correct answer with the same formulas nad very similar data. However I would like to know for future reference, how is this kind of thing possible? does anyone have experience.

PS this has happened on Excel 2010 and 2007.

PPS my options are fine, also I did it both accepting and not accepting nt accepting negative values for non-constrained variables (the assignment requires both options).

Thank you so much to any expert who can help.