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
Tabs and Dark Mode
cjc2112 in Discussions on
30 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
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies