When you copy a worksheet that contains a Solver model, the Solver model is not saved with the new worksheet unless you save it as a model in a blank area of the worksheet and load the Solver model into the new worksheet.

Question

Quizplus · Accepted Answer

When you copy a worksheet that contains a Solver model, the model is not automatically saved with the new worksheet. To save the model, you must manually save it as a model in a blank area of the new worksheet and load it into the Solver add-in.

When You Copy a Worksheet That Contains a Solver Model