#Microsoft excel protected sheet upgrade
Upgrade to Controller 10.1.1 RP1 FP1 () or later. I have a sheet with several formatted cells. Scenario #4 - Code production problem (defect reference APAR PM74277) in Controller and earlier. TIP: For more details, see separate IBM Technote #1347695.
![microsoft excel protected sheet microsoft excel protected sheet](https://media.idownloadblog.com/wp-content/uploads/2020/09/How-to-Lock-Cells-in-Excel-on-Mac.jpg)
Scenario #3 - The Controller superuser has added new accounts in the form.Īsk the Controller superuser to generate the movement account. For more details of how 'security company groups' work, see separate IBM Technote #1663765.
![microsoft excel protected sheet microsoft excel protected sheet](https://www.howtogeek.com/wp-content/uploads/2018/06/office_excel_lede.png)
For more details of 'security form groups', see separate IBM Technote #1346073.Scenario #2 - User has a 'security group' (associated with their user ID) which is set to read-only.Ĭhange security setting of relevant group (which the user belongs to) to Read / Write, or change the group (that the user belongs to) to be a different group (one that has Read/Write access to the relevant form parameters). or choose a different period (which is unlocked).Confirm the password in the Reenter Password box, and then select OK. Enter a password in the Password box, and then select OK. Scenario #1 - User has opened a data entry form, but has chosen a period that is locked Select the Protect Workbook box and choose Encrypt with Password.