Home

Enable copying protected sheets and keeping cell protection intact

%3CLINGO-SUB%20id%3D%22lingo-sub-449376%22%20slang%3D%22en-US%22%3EEnable%20copying%20protected%20sheets%20and%20keeping%20cell%20protection%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-449376%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20want%20to%20share%20Excel%20for%20co%20authoring%20and%20want%20to%20protect%20a%20sheet%20but%20keep%20copying%20sheet%20rights%20open.%26nbsp%3B%20But%20when%20I%20protect%20some%20cells%20of%20the%20sheets%2C%20the%20other%20users%20are%20unable%20to%20copy%20that%20sheets%20which%20is%20exactly%20I%20don't%20want.%26nbsp%3B%20In%20brief%2C%20I%20want%20other%20users%20restricted%20from%20editing%20the%20sheet%20formulas%20but%20should%20be%20able%20to%20copy%20sheets%20retaining%20the%20cell%20protection.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-449376%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-453601%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20copying%20protected%20sheets%20and%20keeping%20cell%20protection%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-453601%22%20slang%3D%22en-US%22%3EAFAIK%20you%20should%20be%20able%20to%20copy%20a%20protected%20sheet%2C%20perhaps%20you%20also%20protected%20the%20workbook%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455035%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20copying%20protected%20sheets%20and%20keeping%20cell%20protection%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455035%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BI%20tried%20when%20the%20restricted%20user%20try%20to%20copy%20the%20sheet%20it%20will%20not%20save%20and%20gives%20error%20that%20it%20is%20in%20read%20only%20mode.%20I%20think%20that%20the%20excel%20is%20designed%20in%20that%20way%20only.%20We%20don't%20have%20option%20to%20exclude%20%22copy%20sheet%22%20while%20enabling%20protection.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455611%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20copying%20protected%20sheets%20and%20keeping%20cell%20protection%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455611%22%20slang%3D%22en-US%22%3EEhm%2C%20you%20now%20mention%20wanting%20to%20exclude%20%22copy%20sheet%22%20while%20earlier%20you%20said%20the%20opposite%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455720%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20copying%20protected%20sheets%20and%20keeping%20cell%20protection%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455720%22%20slang%3D%22en-US%22%3ENo%2C%20I%20said%20when%20protecting%20a%20sheet%2C%20there%20are%20options%20to%20select.%20I%20said%2C%20there%20is%20no%20option%20to%20deselect%20%22copy%20sheets%22%20and%20make%20it%20open%20to%20other%20users.%20There%20is%20nothing%20complicated%2C%20I%20just%20want%20the%20other%20users%20to%20copy%20my%20protected%20sheet%20and%20use%20it%20further%20without%20changing%20its%20formulas.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-455788%22%20slang%3D%22en-US%22%3ERe%3A%20Enable%20copying%20protected%20sheets%20and%20keeping%20cell%20protection%20intact%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455788%22%20slang%3D%22en-US%22%3EThe%20reason%20there%20is%20no%20such%20option%20is%20that%20protecting%20a%20worksheet%20has%20never%20prevented%20users%20from%20copying%20that%20worksheet.%20I%20just%20tried%20on%20a%20shared%20workbook%20(that%20is%20on%20a%20workbook%20stored%20in%20either%20OneDrive%20or%20Sharepoint%20in%20Office%20365)%20and%20after%20protecting%20the%20sheet%20I%20can%20still%20copy%20it.%20The%20copy%20of%20the%20sheet%20inherits%20the%20same%20protection.%3C%2FLINGO-BODY%3E
Crusader36
New Contributor

Hi

I want to share Excel for co authoring and want to protect a sheet but keep copying sheet rights open.  But when I protect some cells of the sheets, the other users are unable to copy that sheets which is exactly I don't want.  In brief, I want other users restricted from editing the sheet formulas but should be able to copy sheets retaining the cell protection.

5 Replies
AFAIK you should be able to copy a protected sheet, perhaps you also protected the workbook?

@Jan Karel Pieterse I tried when the restricted user try to copy the sheet it will not save and gives error that it is in read only mode. I think that the excel is designed in that way only. We don't have option to exclude "copy sheet" while enabling protection.

Ehm, you now mention wanting to exclude "copy sheet" while earlier you said the opposite?
No, I said when protecting a sheet, there are options to select. I said, there is no option to deselect "copy sheets" and make it open to other users. There is nothing complicated, I just want the other users to copy my protected sheet and use it further without changing its formulas.
The reason there is no such option is that protecting a worksheet has never prevented users from copying that worksheet. I just tried on a shared workbook (that is on a workbook stored in either OneDrive or Sharepoint in Office 365) and after protecting the sheet I can still copy it. The copy of the sheet inherits the same protection.
Related Conversations