Editing protected Excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-2159287%22%20slang%3D%22de-DE%22%3EEditing%20protected%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2159287%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20workbook%20which%20is%20protected.%20When%20I%20upload%20it%20into%20the%20Document%20Library%20and%20try%20to%20open%20the%20excel%20file%20there%2C%20it%20works%20-%20Excel%20is%20asking%20for%20the%20password.%20But%2C%20when%20I%20enter%20the%20password%2C%20the%20file%20is%20only%20opened%20in%20a%20read%20only%20view%20and%20nobody%20could%20edit%20the%20cells%20and%20that's%20not%20the%20idea.%20Furthermore%2C%20when%20I%20upload%20the%20same%20file%20without%20a%20protection%2C%20all%20cells%20could%20be%20edited%20normally.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%40B71AFCCE02F5853FE57A20BD4B04EADD%2Fimages%2Femoticons%2Fcool_40x40.gif%22%20alt%3D%22%3Acool%3A%22%20title%3D%22%3Acool%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20help%20me%2C%20how%20could%20I%20solve%20this%20problem%3F%20Thank%20you%20very%20much!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2159287%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

I have an excel workbook which is protected. When I upload it into the Document Library and try to open the excel file there, it works - Excel is asking for the password. However, when I enter the password, the file is only opened in a read only view and nobody could edit the cells and that's not the idea. Furthermore, when I upload the same file without a protection, all cells could be edited normally. :cool:

 

Could you help me, how could I solve this problem? Thank you very much! 

0 Replies