Be aware of excel SOLVER 2

[yakpol]

I encountered a very interested behavior of Excel Solver. After execution of solver (no vba macros) a few range names I assigned simply disappeared or got erased from the memory. Wonder if anybody else experienced this kind of problem.

 

[joerd]

Even though the Solver is very convenient, I don't think it's very well programmed. It adds a lot of range names to do its work, and (maybe) tries to clean things up, deleting your range names in the process. Thanks for bringing it up, one more thing to look out for!
[tt]
Sheet1!solver_adj
Sheet1!solver_cvg
Sheet1!solver_drv
Sheet1!solver_est
Sheet1!solver_itr
Sheet1!solver_lhs1
Sheet1!solver_lhs2
Sheet1!solver_lin
Sheet1!solver_neg
Sheet1!solver_num
Sheet1!solver_nwt
Sheet1!solver_opt
Sheet1!solver_pre
Sheet1!solver_rel1
Sheet1!solver_rel2
Sheet1!solver_rhs1
Sheet1!solver_rhs2
Sheet1!solver_scl
Sheet1!solver_sho
Sheet1!solver_tim
Sheet1!solver_tol
Sheet1!solver_typ
Sheet1!solver_val
[/tt]

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[yakpol]

Thanks Joerd, It could be the answer. I'll play with range names to see if it makes any difference.