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
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies