Excel Online; Log out other users to allow admin/owner to edit in Desktop Excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-13425%22%20slang%3D%22en-US%22%3EExcel%20Online%3B%20Log%20out%20other%20users%20to%20allow%20admin%2Fowner%20to%20edit%20in%20Desktop%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-13425%22%20slang%3D%22en-US%22%3EI%20have%20an%20Excel%20file%20shared%20with%20about%2020%20other%20users.%20To%20protect%20some%20of%20the%20cells%2C%20I%20have%20protected%20the%20worksheets%20with%20a%20password.%20However%20whenever%20I%20want%20to%20make%20changes%20in%20the%20protected%20cells%2C%20I%20would%20need%20to%20edit%20the%20workbook%20in%20the%20desktop%20Excel.%20To%20be%20able%20to%20do%20this%2C%20I%20would%20need%20to%20have%20all%20other%20users%20log%20out%20since%20I%20can't%20do%20this%20as%20other%20users%20are%20editing%20or%20simply%20logged%20on%20to%20this%20file.%20This%20is%20time%20consuming%20and%20inefficient.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20questions%3A%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Is%20it%20possible%20to%20unlock%20workbooks%20edit%20then%20lock%20again%20with%20a%20password%3F%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20If%20the%20answer%20to%201%20above%20is%20%22No%22%20then%20is%20it%20possible%20to%20allow%20the%20owner%20of%20the%20workbook%20to%20log%20out%20all%20other%20users%20to%20allow%20editing%20in%20desktop%20excel%3F%3CBR%20%2F%3E%3CBR%20%2F%3ETim%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-13425%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-14564%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3B%20Log%20out%20other%20users%20to%20allow%20admin%2Fowner%20to%20edit%20in%20Desktop%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14564%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20%22correct%22%20solution%20would%20be%20to%20allow%26nbsp%3Bediting%20in%20Desktop-Excel%20for%20many%20users%20(similar%20to%20OneNote).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20other%20%22correct%22%20solution%20would%20be%20to%20ask%20the%20user%20for%20the%20password%20for%20locked%20cells%20%3CSTRONG%3Eonce%3C%2FSTRONG%3E%20in%20the%20online%20version%20and%20thus%20unlock%20everything%20for%20that%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBoth%20are%20features%20that%20are%20missing%20for%20quite%20a%20long%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-13523%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%3B%20Log%20out%20other%20users%20to%20allow%20admin%2Fowner%20to%20edit%20in%20Desktop%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-13523%22%20slang%3D%22en-US%22%3EWhat's%20your%20idea%20for%201)%3F%20And%20for%202)%20I'm%20pretty%20sure%20it's%20not%20possible%3C%2FLINGO-BODY%3E
Visitor
I have an Excel file shared with about 20 other users. To protect some of the cells, I have protected the worksheets with a password. However whenever I want to make changes in the protected cells, I would need to edit the workbook in the desktop Excel. To be able to do this, I would need to have all other users log out since I can't do this as other users are editing or simply logged on to this file. This is time consuming and inefficient.

My questions:

1. Is it possible to unlock workbooks edit then lock again with a password?

2. If the answer to 1 above is "No" then is it possible to allow the owner of the workbook to log out all other users to allow editing in desktop excel?

Tim
2 Replies
What's your idea for 1)? And for 2) I'm pretty sure it's not possible

The "correct" solution would be to allow editing in Desktop-Excel for many users (similar to OneNote).

 

The other "correct" solution would be to ask the user for the password for locked cells once in the online version and thus unlock everything for that user.

 

Both are features that are missing for quite a long time.