identify sheets that an email address has viewing access to and remove them

smartin

I see in my "User type report" that I have an email address of an old client with viewing access of 1 sheet. How do I find the sheet they have viewing access of and remove them? They were never a licensed user, but had been given viewing access to a sheet long ago. We have hundreds of sheets so need to determine which sheet they have access to.

I can't find a way to search by email to see what sheets they have viewing access to.

Genevieve P.

Hi @smartin

If you're a System Admin, you can download a sheet access report! From this you can search for that email address to find the Sheet name. Then you can filter by the Sheet name to see who else is shared to it and may be able to remove them for you.

Cheers,

Genevieve

Genevieve P.

Hi @smartin

If you're a System Admin, you can download a sheet access report! From this you can search for that email address to find the Sheet name. Then you can filter by the Sheet name to see who else is shared to it and may be able to remove them for you.

Cheers,

Genevieve

smartin

Thank you! That worked perfectly.