hide the spreadsheet which is called beregningsark opg. 3, and still be able to use the solver button in the Samlet Uddata
First of all, the way solver is set up this will not work as you found out. Extract from the solver home page:
By Changing Cells must be on the active sheet.
A limitation of the Solver is that all of the decision variables (adjustable or changing cells) in the By Changing Cells edit box must be cells on the active sheet. (This limitation makes the Solver considerably faster than if adjustable cells were allowed to be on any sheet.) You should re-design your Solver model so that all decision variables are on one sheet, and try again.
What you could do is writing a macro that starts by "freezing" the screen using
then the macro should activate the hidden sheet and run solver using the command
then copy this result to another sheet and hide sheet " beregningsark opg. 3" and finally "un freeze" the screen with command
Alf
Bookmarks