Does anyone have a trick to remove sharing of multiple users on multiple sheets?

Ami Veltrie
Ami Veltrie ✭✭✭✭✭✭

I have a terminated user who owed 2000+ sheets. I need to remove sharing on all the sheets before I earmark them for future deletion. Has anyone figured out a way to bulk remove sharing of multiple sheets and multiple users?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    That's what I was hoping you weren't going to say. Haha.

    Unfortunately it sounds like you have either a grueling manual process or some API coding ahead of you.

    Or... What if you made a copy of the sheets and deleted the originals? If someone needs it, they can be shared to the copy. The "catch" with this method is that any sheets linked together will need to be dropped into a folder and copied at the same time to maintain the links, and any reports/dashboards referencing these sheets will need updated. So it may not work for everything, but it may help narrow things down a little bit.

    And that is a good method for workspace level sharing.