Home

Excel Protected Timesheets

Mark_Barrett
New Contributor

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?....

4 Replies
I expect it simply means Android Excel does not have that particular feature. Have you tried using Excel on-line for this (so opening the file from OneDrive in the browser)? Does it allow you to use the feature?

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?

@Mark_Barrett Can you instruct about  creat password for rank on excel online? I can't do it. Thanks so much.

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies