Home

Protect a workbook and solver

%3CLINGO-SUB%20id%3D%22lingo-sub-788199%22%20slang%3D%22en-US%22%3EProtect%20a%20workbook%20and%20solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788199%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20a%20workbook%20on%20Excel%20and%20then%20I%20will%20share%20with%20lots%20of%20people.%20Before%20sharing%20I%20will%20protect%20the%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20problem%20is%20the%20following%20%3A%20some%20cells%20are%20not%20blocked%20because%20the%20people%20have%20some%20define%20cells%20where%20they%20can%20change%20the%20values.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20some%20iterative%20calculation%20and%20to%20solve%20faster%2C%20I%20put%20the%20excel%20solver.%20But%20when%20I%20blocked%20the%20sheet%2C%20the%20solver%20becomes%20inusable.%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20solution%20to%20use%20it%20while%20using%20the%20solver%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20you%20a%20lot%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECha%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-788199%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-789620%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20a%20workbook%20and%20solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-789620%22%20slang%3D%22en-US%22%3EYou%20must%20also%20unlock%20the%20cells%20that%20solver%20tries%20to%20change.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790392%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20a%20workbook%20and%20solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790392%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BI%20did%20it%20but%20when%20I%20try%20to%20use%20the%20solver%2C%20I%20had%20a%20pop%20up%20message%20that%20says%20that%20the%20document%20is%20not%20a%20calculation%20sheet%20or%20it%20is%20protected.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790400%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20a%20workbook%20and%20solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790400%22%20slang%3D%22en-US%22%3EPerhaps%20that%20is%20a%20limitation%20solver%20has%3F%20I%20don't%20really%20know.%20AT%20least%20you%20must%20make%20sure%20that%20all%20cells%20solver%20tries%20to%20use%20must%20be%20unlocked.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790411%22%20slang%3D%22en-US%22%3ERe%3A%20Protect%20a%20workbook%20and%20solver%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790411%22%20slang%3D%22en-US%22%3EHmm%2C%20I%20just%20tested%20and%20it%20appears%20that%20solver%20does%20not%20work%20on%20a%20protected%20worksheet.%20Apologies%20for%20wasting%20your%20time!%3C%2FLINGO-BODY%3E
Highlighted
Cha_Cha
New 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!
Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies