Apr 13 2019 01:27 AM
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.
Apr 15 2019 04:18 AM
Apr 15 2019 08:07 AM - edited Apr 15 2019 08:07 AM
@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.
Apr 15 2019 09:26 AM
Apr 15 2019 09:44 AM
Apr 15 2019 09:56 AM
Dec 11 2020 03:03 AM
@Crusader36 did you ever figure out a way to do this? I have the same challenge... its specific to the online version of Excel as it works when using the desktop app.