Protect a workbook and solver

Copper Contributor

Good morning,

 

I did a workbook on Excel and then I will share with lots of people. Before sharing I will protect the sheet. 

My problem is the following : some cells are not blocked because the people have some define cells where they can change the values. 

I have some iterative calculation and to solve faster, I put the excel solver. But when I blocked the sheet, the solver becomes inusable. 

There is a solution to use it while using the solver? 

 

Thanks you a lot,

 

Cha

4 Replies
You must also unlock the cells that solver tries to change.

 @Jan Karel Pieterse I did it but when I try to use the solver, I had a pop up message that says that the document is not a calculation sheet or it is protected. 

Perhaps that is a limitation solver has? I don't really know. AT least you must make sure that all cells solver tries to use must be unlocked.
Hmm, I just tested and it appears that solver does not work on a protected worksheet. Apologies for wasting your time!