Enable copying protected sheets and keeping cell protection intact

Question

HiI want to share Excel for co authoring and want to protect a sheet but keep copying sheet rights open.&nbsp; 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.&nbsp; In brief, I want other users restricted from editing the sheet formulas but should be able to copy sheets retaining the cell protection.

jkpieterse · Answer

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

crusader36 · Answer

JKPieterse&nbsp;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.

jkpieterse · Answer

Ehm, you now mention wanting to exclude "copy sheet" while earlier you said the opposite?

crusader36 · Answer

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.

jkpieterse · Answer

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.

Forum Discussion

Enable copying protected sheets and keeping cell protection intact

6 Replies

Resources