thanks Kanti. i tried your suggested method but could not fix the problem. at the same time stuck with another issue. i have made an excel optimizer sheet using solver. this sheet was working fine till i uses 10 data sets. as i fill in with 50 data sets it goes haywire. to explain this i need to...
i have to run solver on four different sheets. output of 1st sheet will be used as input of 2nd and so on. i have recorded a macro to run the solver for all 4 sheets one by one. but when i run the macro it stops at every sheet and ask to enter manually to confirm "keep the result". can anybody...