identify sheets that an email address has viewing access to and remove them
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.
Best Answer
-
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
Answers
-
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
-
Thank you! That worked perfectly.
