Solver in my older version doesn't support all of the options in the newer versions, so I may be losing something when I open the OP's file with my version of Excel. Can some of you with a newer version open and check the Solver model and see if there is something I am missing in my older version of Excel?

https://www.excelforum.com/excel-for...-an-error.html