Saving and retrieving workbooks

The Solver option under Tools can be used to find values of variables maximising or minimising a function, known as the objective function, under constraints. If Solver is not showing in the version of Excel you are using, you need to go to Add-Ins (under Tools) first and check the Solver Add-in box. ................
................