Copy Sharing when duplicating (Save as New) sheet.

Skip Robertshaw

We create (copy) a new sheet each month, keeping all the formatting but not the attachments and comments and cell lnks.  Is there a way to duplicate the sharing as well.  The sheets are in the "Sheets" folder.

 

I have created a Workspace with the sharing, but when I move or copy the sheet to the "Sheets" folder, the sharing is gone

 

Shaine Greenwood

Hi Skip,

 

There isn't a way to preserve sharing when copying a sheet to the Sheets folder, you'd need to copy the sheet and keep it within the same workspace to maintain the sharing.

 

I've got your vote down on our enhancement request list for further review by our Product team to maintain sharing of a sheet when copying it, regardless of where the copy is saved.