If you know the email addresses of the people you have shared files with, all you have to do is enter the following search in Google Drive's search bar:
to: [email address]
Google Drive will then show all files shared with that user.
I know this answer is a bit late, but there is a new solution to this problem.
Check out https://whohasaccess.com to uncover all the people that access your shared files and folders.
Disclaimer: I'm part of the team that developed WhoHasAccess.
It's probably because you weren't invited individually to the file:
If you share your file with a link, you may not see the names of
people who view it.
People you didn’t invite individually will show as anonymous when they’re in the file.
People you invite individually will show by name when they’re in the file.
You can only see ...
This was an issue with the sharing settings on the sheets.
It looks like a sheet that is set to Specific People in the sharing settings cannot be automatically imported into a second sheet. If you have access to the first sheet, you can set up an IMPORTRANGE, but it will not update.
The sharing permissions on the first sheet need to be set in such a way ...
One possibility is that the other "Anonymous" visitors are actually you visiting the page multiple times. Since it does not require authentication, it typically leaves people as anonymous until they do something that identifies them.
I tested the following using 2 unique Gmail accounts:
User Alice created a Google Group and invited User Bob to join.
Alice created a Google Doc and wrote text.
Alice shared the Google Doc with the Google Group via the group email address GROUP_NAME@googlegroups.com.
Bob could view everything written so far and can edit the document.
Alice then removed Bob ...
After a few harrowing minutes, I managed to solve this problem. I'll preserve the thread in case anyone else screws themselves in such a manner.
Using the drive which created the file, click on the information icon in the upper right.
Under the "activity" tab, you should see a list of actions with the accompanying files.
Click the files/folders to open.
When you pull up the share menu - click the little drop down an choose "view"
ALso if you want to disable copying and downloading, click on "advanced" on the bottom right and check the 2 boxes at the bottom
I had the very same problem. This worked for me:
I am admin of groups A and B of google accounts. Groups have some privileges on some folders. I add Bob to group B. Bob gains all privileges that group B has.
Bob logs in Drive. He must search for the most rooted folder that group B has some privilege on. To do the search, search bar at top is used, the ...
I was trying to find every file that had owners that were not myself as well, it was driving me crazy. Somehow there were a good amount of files and folders in there that I never remember having added at all. Not sure at all how that happened. Anyways, after playing around for a bit I found that if you search at the top, use:
That will show every ...
I just ran into this same issue...we've never had an issue with importrange working across MANY sheets which are selectively shared, but today it randomly stopped working. I ran upon this article in my research.
Upon further investigation, I found that only one spreadsheet that was failing to export--the importrange functions on that sheet were still ...
https://support.google.com/a/answer/6008339?hl=en states that a search in Drive for is:unorganized owner:me returns orphaned items that you own. Note that it returns the top-level folder if a folder hierarchy has been orphaned.
From there you can use Move... to add item en masse to your own Drive.
EDIT: Some parts of this answer are now obsolete as Find your files - Drive Help was updated recently. This was noted thanks to the answer by Dean Ransevycz
At this time Google Drive doesn't include a view nor a search operator to find only orphaned files. From :
To find an orphaned item, do one of the following:
Search for the item in the ...
It's not about the way you shared; it's about the locale that you use for each spreadsheet.
Go to File -> Spreadsheet Setting -> and make sure you have same Locale and Time zone for both Google sheets. The one you put your data and calculations, and the one you shared with the others, and you used importrange() on it.
I already mentioned this on a recent question When sharing folders on Google Drive do users know who else the folder is shared with
Users that are explictely included on the sharing settings could see
who else has access to the file. To prevent this, create a Google
Group, add the collaborators (editors/viewers) to that group then
share the folder ...
I just spent an hour with Google support on this issue. Their solution: once you have added your new user(s), conduct a search from your group email address. Select all item then un-assign the group after the group has be removed then re-assign the group back to the selected item.
Wish I had better news. As it stand for our business, we are having to re-...
The best way to handle sharing files with large and dynamic groups on Google Drive is by using Google Groups, but it's also possible to do the way you are thinking by using Google Apps Script or the Google Drive API and the Google Sheets API
To use a group from Google Groups to handle sharing files, share the files with the group by adding its email address....
Unless something has changed, Google Groups aliases should always dynamically change permissions based on people's membership in the group.
The problem it sounds like you're having is that these docs aren't showing up in UserC's doc list. This is because UserC must first open the document before it will be added and remain in the doc list.
For a single ...
When sharing, the default setting is to allow anyone who has Edit rights to also Share the document.
When you open the share window, you should see some small text at the bottom that says:
"Editors will be allowed to add people and change the permissions. [Change]"
Click on change, and then change the setting to "Only the owner can change the ...
I needed this so bad for my Google Apps account!
After a bit of searching, I found this post which uses a Google Script to scan all folders/files and sends you an email of all people who can access your Google Drive files.
I have run into this before. If you are using a Google Form, Google is under anonymous when it re-uploads more information. It could also be you (Or the owner of the document) isn't allowing others to see the information. Next to the comment button in the top right of the screen there is a little lightning bolt line with an arrow pointing up. If you click on ...
This is what I have found out.
Add formula =importRange(«url of file B»,«range») to file A. This makes the content of part of one file appear in the other (the one with the formula.
Share file A, read only (Do not give edit/write permissions. If you give edit/write permission then they can gain read access to the other file, my editing or adding an ...