Unprotected worksheet cells locked

%3CLINGO-SUB%20id%3D%22lingo-sub-2089294%22%20slang%3D%22en-US%22%3EUnprotected%20worksheet%20cells%20locked%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089294%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20protected%20some%20cells%20within%20the%20excel%20worksheet%20for%20editing.%20This%20was%20done%20via%20the%20excel%20app%20on%20my%20laptop%2C%20not%20on%20the%20web%20platform.%3CBR%20%2F%3EYet%20when%20you%20open%20the%20worksheet%20on%20the%20web%20based%20excel%20all%20the%20cells%20are%20locked%20for%20editing%2C%20even%20the%20unprotected%20one's.%3CBR%20%2F%3EHow%20do%20you%20get%20the%20unprotected%20cells%20to%20be%20editable%20on%20the%20web%20excel%20platform%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2089294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2089743%22%20slang%3D%22de-DE%22%3ESubject%3A%20Unprotected%20worksheet%20worksheet%20cells%20locked%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089743%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F939816%22%20target%3D%22_blank%22%3E%40Dick_van_Dijk%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22x-hidden-focus%22%3EWhen%20you%20try%20to%20open%20a%20workbook%20in%20Microsoft%20Excel%20for%20the%20web%2C%20you%20might%20see%20an%20error%20message%20that%20tells%20you%20the%20workbook%20contains%20features%20that%20are%20not%20supported%20by%20Excel%20for%20the%20web.%20Unsupported%20features%20are%20contents%20or%20functionality%20in%20a%20workbook%20that%20prevents%20the%20workbook%20from%20being%20opened%20for%20editing%20or%2C%20in%20some%20cases%2C%20viewing%20in%20the%20browser.%20This%20article%20provides%20steps%20to%20edit%20the%20workbook%2C%20depending%20on%20the%20nature%20of%20the%20unsupported%20features%20in%20the%20workbook.%3C%2FP%3E%3CP%3EFor%20details%20about%20feature%20support%20in%20Excel%20for%20the%20web%2C%20see%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%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%22%3EDifferences%20between%20using%20a%20workbook%20in%20the%20browser%20and%20in%20Excel%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWork%20with%20VBA%20macros%20in%20Excel%20for%20the%20web%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwork-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20for%20the%20web%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Fexcel-online%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fservicedescriptions%2Foffice-online-service-description%2Fexcel-online%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have protected some cells within the excel worksheet for editing. This was done via the excel app on my laptop, not on the web platform.
Yet when you open the worksheet on the web based excel all the cells are locked for editing, even the unprotected one's.
How do you get the unprotected cells to be editable on the web excel platform?

1 Reply

@Dick_van_Dijk 

When you try to open a workbook in Microsoft Excel for the web, you might see an error message that tells you the workbook contains features that are not supported by Excel for the web. Unsupported features are contents or functionality in a workbook that prevents the workbook from being opened for editing or, in some cases, viewing in the browser. This article provides steps to edit the workbook, depending on the nature of the unsupported features in the workbook.

For details about feature support in Excel for the web, see Differences between using a workbook in the browser and in Excel.

 

Work with VBA macros in Excel for the web

https://support.microsoft.com/en-us/office/work-with-vba-macros-in-excel-for-the-web-98784ad0-898c-4...

 

Excel for the web

https://docs.microsoft.com/en-us/office365/servicedescriptions/office-online-service-description/exc...

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)