Protect/UnProtect Cells/Work Book with Android App
Not being able to Protect/Unprotect stuff with the android app is a big hindrance. If I am not in the office and I need to make a quick update to an excel sheet I am unable to since I cant unprotect the sheet. That means I have to wait until I get back to the office to do anything and sometimes it is a time sensitive issue that needs to be resolved asap. Implementing this into the android app would be a great addition and help streamline the experience.
I have the same issue, not being able to lock formulas. Kind of lame. Just spend two hours on a new calculating app where 95% of the cells need to be protected. I was hoping to distribute it to my field reps but. Without protection for the formulas I see no way this can be released. One mis typed cell and it would be junk. Hummmmm.
This is a very old issue. IT IS TIME THEY RESOLVE IT AT ONCE. WE PAY FOR THE BLODY SOFTWARE, WE DEMAND OFF MICROSOFT TO ADD THE OPTION TO PROTECT THE CELLS ALREADY.
To the question of protect cells in Android: If you start out creating your excel sheet on a computer, I found that if I first save a sheet I've created with protected cells as .ods on my computer; then, reopen the .ods version and save-as .xlsx, the protected cells are maintained when I open the sheet in excel for Android.
I use an excel application on an android device where data entry is made with multiple users. To avoid deleting formulae, I need to protect some of the cells. The process works on my computer where I developed the spreadsheet, but when I send it to the tablet, no cells are protected, so errors occur and formulae are at risk. How do I protect cells using excel on my android device?
This issue is broader than originally noted. I have a spreadsheet I ONLY use with the Android app and I want to prevent myself from inadvertently clearing or deleting my formulae. And also, it would be easy, then, to select the entire spreadsheet and clear it, to get rid of my temporary data.
How do I unprotect a workbook.