Hello everyone! I have a question regarding the Solver add-in for Excel.

If I have a constraint dealing with values on different sheets of the same workbook, solver will not retain the workbook the cells are on.

For example, this constraint:
$A$1 <= Sheet2!$A$1

If the solver window is closed and reopened the constraint will no longer reference Sheet 2 and will look like this:
$A$1 <= $A$1

Is there a fix for this? For large problems it can be more convenient to move some calculations off the active sheet to save space and it gets frustrating to rebuild the constraints every time the problem needs to be re-run.
Thanks in advance!