Mar 05 2019 03:53 AM
Hi, I'm trying to set up online timesheets for our remote engineering staff using Excel. I have Protected the Sheet and Workbook to avoid any "accidents" when being completed and used Allow Edit Ranges for the cells that need completing. This all works well on my PC and prompts for a password before entering anything in the allowed cells but I can't get it to work on Android - double tap on the cell just says "This sheet is protected. Some parts may be view-only and can't be changed". Am I missing something obvious?....
Mar 05 2019 06:56 AM
Mar 05 2019 07:15 AM
Tried opening on the Android device using Microsoft Excel app, OneDrive app and Excel Online through the Chrome and Samsung browsers but none allow me to edit?
Mar 19 2019 09:30 PM
@Mark_Barrett Can you instruct about creat password for rank on excel online? I can't do it. Thanks so much.
Mar 20 2019 01:57 AM
@Candydung01061983 The way I've found is under Review then Protect Sheet/Workbook to password protect everything or you can use Allow Edit Ranges to protect everything but selected cells. This seems to work on PC but not with our Android devices through either the Excel app or via a browser.