Home

Excel worksheet protection in Excel Online

%3CLINGO-SUB%20id%3D%22lingo-sub-136408%22%20slang%3D%22en-US%22%3EExcel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-136408%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20worksheet%20protection%20work%20in%20Excel%20Online%3F%26nbsp%3B%20We%20have%20a%20workbook%20where%20we%20have%20set%20certain%20ranges%20for%20all%20users%20(Everyone)%20to%20be%20able%20to%20edit%20without%20password.%26nbsp%3B%20Enable%20protection%20on%20the%20worksheet%20and%20share%20the%20workbook%20in%20OneDrive.%26nbsp%3B%20Users%20open%20the%20Excel%20file%20in%20Excel%20Online%20and%20states%20range%20is%20protected.%20Users%20edit%20in%20Desktop%20Excel%20and%20they%20can%20edit%20the%20cells.%26nbsp%3B%20I%20tried%20to%20find%20relevant%20articles%20about%20if%20this%20is%20a%20limitation%20to%20Excel%20Online%2C%20but%20they%20are%20not%20clear.%26nbsp%3B%20Should%20ranges%20%2F%20sheet%20protection%20work%20in%20Excel%20Online%2C%20or%20is%20this%20a%20limitation%3F%26nbsp%3B%20Or%20are%20we%20doing%20something%20wrong%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3EFound%20references%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22TechNet%22%20href%3D%22https%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fexcel-online-service-description.aspx%23Sheet%20protection%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fexcel-online-service-description.aspx%23Sheet%20protection%3C%2FA%3E%3C%2FP%3E%0A%3CDIV%3E%0A%3CDIV%20id%3D%22Anchor_50%22%20class%3D%22LW_CollapsibleArea_Anchor_Div%20active%22%3E%22When%20you%20share%20an%20Excel%20file%20with%20other%20users%2C%20you%20can%20protect%20a%20worksheet%20to%20help%20prevent%20it%20from%20being%20changed%2C%20and%20you%20can%20choose%20the%20actions%20that%20you%20allow%20the%20users%20of%20your%20worksheet%20to%20perform.%22%3C%2FDIV%3E%0A%3CDIV%20class%3D%22LW_CollapsibleArea_Anchor_Div%20active%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20class%3D%22LW_CollapsibleArea_Anchor_Div%20active%22%3E%3CA%20title%3D%22Office%20Support%22%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FDifferences-between-using-a-workbook-in-the-browser-and-in-Excel-F0DC28ED-B85D-4E1D-BE6D-5878005DB3B6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FDifferences-between-using-a-workbook-in-the-browser-and-in-Excel-F0DC28ED-B85D-4E1D-BE6D-5878005DB3B6%3C%2FA%3E%3C%2FDIV%3E%0A%3CDIV%20class%3D%22LW_CollapsibleArea_Anchor_Div%20active%22%3E%3CSPAN%3E%22Protected%20worksheets%20(not%20entire%20workbooks)%20can%20be%20viewed%20in%20a%20browser%20window%20in%20Excel%20Online.%22%3C%2FSPAN%3E%3C%2FDIV%3E%0A%3CDIV%20class%3D%22LW_CollapsibleArea_Anchor_Div%20active%22%3E%26nbsp%3B%3C%2FDIV%3E%0A%3CDIV%20class%3D%22LW_CollapsibleArea_Anchor_Div%20active%22%3EThanks%2C%3C%2FDIV%3E%0A%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-136408%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-169217%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-169217%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20quick%20answer.%20It's%20a%20pity%2C%20since%20worksheet%20protection%20makes%20a%20lot%20of%20sense%20in%20collaborative%20editing%2Fmulti%20user%20editing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%40%26nbsp%3BMicrosoft%2C%20any%20plan%20to%20fix%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EAlex%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168861%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168861%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Alexander%2C%20I%20have%20not%20resolved%20this%20issue%20and%20and%20no%20one%20else%20has%20responded%20to%20my%20post.%26nbsp%3B%20So%20no%20solution%20yet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-168855%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-168855%22%20slang%3D%22en-US%22%3E%3CP%3EI%20see%20the%20same%20behaviour%2C%20and%20it%20is%20also%20the%20same%20when%20using%20an%20Excel%20file%20in%20MS%20Teams.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84154%22%20target%3D%22_blank%22%3E%40Michael%20Bennett%3C%2FA%3E%2C%20have%20you%20ever%20found%20a%20solution%20to%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBest%2C%3C%2FP%3E%0A%3CP%3EAlex%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-483540%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-483540%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F125936%22%20target%3D%22_blank%22%3E%40Alexander%20Sch%C3%B6cke%3C%2FA%3E%26nbsp%3BExperiencing%20similar%20frustrations%20here.%20Microsoft%2C%20what%20are%20you%20doing%20to%20resolve%20this%20issue%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-683738%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683738%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F84154%22%20target%3D%22_blank%22%3E%40Michael%20Bennett%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem%2C%20did%20Microsoft%20come%20up%20with%20a%20fix%20for%20this%20as%20it%20is%20stopping%20me%20sharing%20a%20database%20that%20I%20have%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20great.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdam%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754357%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754357%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20problem%20is%20there%20any%20fix%20planned%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754388%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754388%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20just%20unprotected%20some%20cells%20in%20Desktop%2C%20protected%20the%20sheet%2C%20published%20to%20OneDrive%2C%20opened%20it%20online%20-%20protection%20is%20working.%26nbsp%3B%20%26nbsp%3BOpened%20in%20Excel%20desktop%2C%26nbsp%3B%20protection%20is%20working.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20getting%20a%20different%20result%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754457%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754457%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20original%20question%20is%20from%202017.%20Excel%20online%20has%20come%20a%20long%20way%20since%20then.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20was%20not%20possible%20then%20may%20be%20possible%20now.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20take%20into%20account%20the%20posting%20date%20of%20the%20question%20and%20consider%20that%20the%20feature%20set%20may%20have%20changed%20since%20it%20was%20asked.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754467%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%20Ok%20so%20I%20choose%20the%20edit%20in%20excel%20option%20and%20locked%20a%20range%20of%20cells%20however%20when%20accessing%20the%20online%20version%20the%20users%20can%20still%20edit%20cells%20I%20do%20not%20want%20edited%2C%20I%20also%20see%20a%20comment%20from%20a%20few%20weeks%20ago%20highlighting%20the%20same%20issue%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754470%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754470%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376311%22%20target%3D%22_blank%22%3E%40GHepburn%3C%2FA%3E%26nbsp%3BAfter%20locking%20the%20cells%2C%20did%20you%20protect%20the%20sheet%3F%20Can%20you%20detail%20where%20the%20workbook%20is%20saved%3F%20SharePoint%3F%20OneDrive%3F%20OneDrive%20for%20Business%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754485%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754485%22%20slang%3D%22en-US%22%3E%3CP%20dir%3D%22ltr%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F376311%22%20target%3D%22_blank%22%3E%40GHepburn%3C%2FA%3EI%20just%20created%20a%20new%20workbook%2C%20unlocked%20some%20cells%20and%20formatted%20them%20with%20a%20green%20fill.%20I%20protected%20the%20worksheet%20and%20saved%20the%20file%20to%20my%20personal%20OneDrive.%20Then%20I%20edited%20the%20file%20in%20the%20browser%20with%20Excel%20online.%20I%20was%20not%20able%20to%20change%20the%20locked%20cells%2C%20only%20the%20unlocked%20green%20cells%20in%20column%20B.%3C%2FP%3E%0A%3CP%20dir%3D%22ltr%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123279i80DE781FE5167AF3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22online%20protection.png%22%20title%3D%22online%20protection.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20dir%3D%22ltr%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20dir%3D%22ltr%22%3EIf%20your%20experience%20is%20different%2C%20please%20provide%20the%20steps%20that%20you%20took.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754648%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754648%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3Bthanks%20managed%20to%20get%20it%20working%20now%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776386%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776386%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3BI%20want%20to%20create%20a%20file%20with%20several%20sheets%2C%20and%20I%20want%20to%20share%20the%20file%20online%20with%20different%20people.%20Is%20there%20a%20way%20in%20which%20I%20can%20protect%20each%20sheet%20with%20a%20password%2C%20so%20each%20participant%20has%20access%20only%20to%20his%20own%20sheet%20like%20I%20can%20do%20with%20desktop%20Excel%3F%20Thank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778226%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20worksheet%20protection%20in%20Excel%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383237%22%20target%3D%22_blank%22%3E%40Randall1508%3C%2FA%3E%26nbsp%3Bwith%20Excel%20online%20it's%20currently%20not%20possible%20to%20remove%20sheet%20protection%20in%20the%20browser%2C%20so%20the%20scenario%20you%20have%20in%20mind%20will%20not%20work%20that%20way.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMind%20you%20that%20sheet%20protection%20is%20not%20a%20security%20feature%20and%20can%20easily%20be%20circumvented.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Michael Bennett
New Contributor

Does worksheet protection work in Excel Online?  We have a workbook where we have set certain ranges for all users (Everyone) to be able to edit without password.  Enable protection on the worksheet and share the workbook in OneDrive.  Users open the Excel file in Excel Online and states range is protected. Users edit in Desktop Excel and they can edit the cells.  I tried to find relevant articles about if this is a limitation to Excel Online, but they are not clear.  Should ranges / sheet protection work in Excel Online, or is this a limitation?  Or are we doing something wrong?  

 

Found references:

https://technet.microsoft.com/en-us/library/excel-online-service-description.aspx#Sheet protection

"When you share an Excel file with other users, you can protect a worksheet to help prevent it from being changed, and you can choose the actions that you allow the users of your worksheet to perform."
 
"Protected worksheets (not entire workbooks) can be viewed in a browser window in Excel Online."
 
Thanks,
14 Replies

I see the same behaviour, and it is also the same when using an Excel file in MS Teams. @Michael Bennett, have you ever found a solution to this?

 

Best,

Alex

 


Hi Alexander, I have not resolved this issue and and no one else has responded to my post.  So no solution yet.

Thanks for the quick answer. It's a pity, since worksheet protection makes a lot of sense in collaborative editing/multi user editing.

 

@ Microsoft, any plan to fix this?

 

Best,

Alex

@Alexander Schöcke Experiencing similar frustrations here. Microsoft, what are you doing to resolve this issue?

@Michael Bennett 

 

Hello 

 

I have the same problem, did Microsoft come up with a fix for this as it is stopping me sharing a database that I have created.

 

Any help would be great.

 

Regards

 

Adam,

I have the same problem is there any fix planned for this?

Hi

 

I just unprotected some cells in Desktop, protected the sheet, published to OneDrive, opened it online - protection is working.   Opened in Excel desktop,  protection is working.

 

Are you getting a different result?

The original question is from 2017. Excel online has come a long way since then. 

 

What was not possible then may be possible now. 

 

Please take into account the posting date of the question and consider that the feature set may have changed since it was asked.

@Ingeborg Hawighorst  Ok so I choose the edit in excel option and locked a range of cells however when accessing the online version the users can still edit cells I do not want edited, I also see a comment from a few weeks ago highlighting the same issue

@GHepburn After locking the cells, did you protect the sheet? Can you detail where the workbook is saved? SharePoint? OneDrive? OneDrive for Business?

@GHepburn I just created a new workbook, unlocked some cells and formatted them with a green fill. I protected the worksheet and saved the file to my personal OneDrive. Then I edited the file in the browser with Excel online. I was not able to change the locked cells, only the unlocked green cells in column B.

online protection.png

 

If your experience is different, please provide the steps that you took.

@Ingeborg Hawighorst thanks managed to get it working now

Hello@Ingeborg Hawighorst I want to create a file with several sheets, and I want to share the file online with different people. Is there a way in which I can protect each sheet with a password, so each participant has access only to his own sheet like I can do with desktop Excel? Thank you. 

@Randall1508 with Excel online it's currently not possible to remove sheet protection in the browser, so the scenario you have in mind will not work that way.

 

Mind you that sheet protection is not a security feature and can easily be circumvented. 

Related Conversations