Unprotect Excel through SharePoint

%3CLINGO-SUB%20id%3D%22lingo-sub-219080%22%20slang%3D%22en-US%22%3EUnprotect%20Excel%20through%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-219080%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20uploaded%20an%20Excel%20Spreadsheet%20to%20SharePoint%20-%20this%20has%20protected%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20to%20update%20the%20locked%20cells%20from%20time-to-time.%26nbsp%3B%20How%20can%20we%20unlock%20the%20cells%20while%20working%20in%20SharePoint%20without%20having%20to%20do%20this%20offline%20and%20then%20re-loading%20the%20document%20to%20SharePoint%20again%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-219080%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPermissions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1064017%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotect%20Excel%20through%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1064017%22%20slang%3D%22en-US%22%3E%3CP%3ESame%20issue%20here.%20Actually%20needs%20this%20function%20on%20Microsoft%20SharePoint.%20If%20Microsoft%20added%20this%20function%2C%20it%20is%20great.%20Is%20it%20depend%20on%20the%20paid%20office%20365%20package%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1131786%22%20slang%3D%22en-US%22%3ERe%3A%20Unprotect%20Excel%20through%20SharePoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1131786%22%20slang%3D%22en-US%22%3E%3CP%3EBUMP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20facing%20this%20same%20issue%20in%20my%20organization.%26nbsp%3B%20There%20needs%20to%20be%20a%20way%20to%20unprotect%20Excel%20worksheets%20from%20the%20web%20browser%20in%20Excel%20in%20SharePoint.%26nbsp%3B%20Not%20all%20users%20have%20the%20ability%20(nor%20should%20they%20have%20to)%20open%20in%20the%20desktop%20app.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have uploaded an Excel Spreadsheet to SharePoint - this has protected cells.

 

We need to update the locked cells from time-to-time.  How can we unlock the cells while working in SharePoint without having to do this offline and then re-loading the document to SharePoint again?

2 Replies
Highlighted

Same issue here. Actually needs this function on Microsoft SharePoint. If Microsoft added this function, it is great. Is it depend on the paid office 365 package?

Highlighted

BUMP

 

We are facing this same issue in my organization.  There needs to be a way to unprotect Excel worksheets from the web browser in Excel in SharePoint.  Not all users have the ability (nor should they have to) open in the desktop app.