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

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
 
B

basilio

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using solver function in a locked (protected) worksheet 2
add Solver as a Reference for protected code in VBA 0
Using Solver in VBA for excel without cell references 1
Using solver with function with multiple outputs 6
How to replace Excel solver with some free solver codes in Excel V 2
Help please - how to run Solver in a protected sheet? 4
Using the Solver in a VBA function (not a macro) 1
Can I make a worksheet with more than 256 columns? 1

Top