Can I use solver function in a locked (protected) worksheet

  • Thread starter Thread starter Niels
  • Start date Start date
N

Niels

I am using the solver function to optimize a blend of products. I want to
lock (protect) some areas of the worksheet, but when doing so the solver
function will not work and the following translated message arrives:

The active document is not a worksheet, is protected or shared.

Hope someone can help me.

Thank you.

Niels
 
I believe the Sover sets numeric values in the cell referenced in the "change
cell" of the solver window. Try to NOT protect this cell.
 
Back
Top