Hi,
I just moved to Excel 2011 (from Excel 2004).
I had a nice simple macro that was just made of a loop calling the solver.
The idea is to change $R$i to optimize $S$i.
Here is the code that works with excel 2004.
The idea is to put "Y' for the lines that need to be solved (so it does not solved for lines already solved).Please Login or Register to view this content.
Here is the problem, I have: it only solves the last line.
There is also something strange going on with the solver in general. Everytime I used it, it launches an new app (solver) bouncing in my dock which disappears after a while. Each optimization is reaaaaallly slow. Does it mean that the solver is not run by excel in the background? Did I miss something when I installed the solver?
Please let me know if I am missing anything obvious or if you have any idea on how to fix the issue.
Cheers
Bookmarks