Excel Solver – Constraints referencing another sheet

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!

Thanks for the quick response.
I feel better knowing that it’s not just me that gets this error.

Originally Posted by shg

Solver requires all the referenced cells to be on the same sheet. You can put a simple formula in a cell to reference a cell on another sheet.

My problem is that Solver will allow references to another sheet, but will forget that it referenced that sheet the next time it is run. The only way I have found to deal with this is to use Solver’s “Load/Save” function because “Load/Save” will remember what sheets were referenced.
My question is, if Solver can remember what sheets it referenced once, is there any way for it to do it every time Solver is opened?