Be aware of excel SOLVER
Be aware of excel SOLVER
(OP)
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.





RE: Be aware of excel SOLVER
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
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Be aware of excel SOLVER