How to lock a spreadsheet in Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-1704190%22%20slang%3D%22en-US%22%3EHow%20to%20lock%20a%20spreadsheet%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1704190%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20lock%20a%20spreadsheet%20to%20be%20view%20only%20in%20Sharepoint.%26nbsp%3B%20There%20has%20to%20be%20an%20answer.%26nbsp%3B%20I%20don't%20want%20to%20make%20it%20by%20permissions%20or%20change%20library%20settings%2C%20just%20to%20lock%20or%20encrypt%20a%20spreadsheet.%3C%2FP%3E%3CP%3EPlease%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1704190%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%20spreadsheet%20encrypt%20lock%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1705263%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20lock%20a%20spreadsheet%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1705263%22%20slang%3D%22en-US%22%3EI%20may%20be%20missing%20something%20but%2C%20it%E2%80%99s%20Excel%2C%20why%20wouldn%E2%80%99t%20you%20just%20use%20the%20Excel%20protection%20functionality%20that%E2%80%99s%20been%20there%20for%20100%20years%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I need to lock a spreadsheet to be view only in Sharepoint.  There has to be an answer.  I don't want to make it by permissions or change library settings, just to lock or encrypt a spreadsheet.

Please help!

3 Replies
Highlighted
I may be missing something but, it’s Excel, why wouldn’t you just use the Excel protection functionality that’s been there for 100 years?
Highlighted

@BradD  thank you for the suggest that is 100 years old.  This is a document created in sharepoint and lives in sharepoint and it does not have all the options that a desktop Excel document has.

Do you have another suggest that maybe isn't as old as the first one?  I really am looking for a solution.

Highlighted

@SheriW but regardless, again, it's still Excel.  I just tested it myself.

 

I created a new workbook, opened it in the desktop app, locked it (and it saved automatically) and then when I go back to the online view, it's locked and I cannot edit it.  You can't edit the protection in the online view but that doesn't stop you from opening it in the desktop app and making those changes.

 

If that's now what you're after then I'm clearly misunderstanding your issue.

 

Brad_Dixon_0-1600898637115.png