Aug 05 2019 07:17 AM
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
Aug 06 2019 01:21 AM
Aug 06 2019 08:20 AM
@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.
Aug 06 2019 08:26 AM
Aug 06 2019 08:29 AM