You can get all your data copy to your drive by using Google Colab.
Just follow the simple steps to get that.
On your drive, create a shortcut to the shared folder
Create new Notebook
Mount your google drive by doing the following:
from google.colab import drive
First right click on the shared ...
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 ...
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
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 ...
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 ...
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.
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.
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.
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 ...
Click 'Shared with Me' on the left side of the Google Drive web interface
Right click the file/folder you would like to keep.
After this there are two options:
Click 'Make a copy', which will locate a copy in your 'My Drive' folder, but that copy will not be synced with anyone else but will be yours even if it is deleted by others
Click 'Add to My ...
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 ...
It's not possible to hide the owner name on shared documents. It could be found either on the Google Documents UI or on Google Drive.
The alternative is to use an account that doesn't include your name on the email address nor the display name.
If you will not allow strangers to edit your documents, another alternative is to publish your files to the web.
Files that are shared with you on Google Drive first appear in the "Shared with me" section. From there, if you wish, you can organize it into folders in your own drive. When you remove a shared file, be it within the shared with me or in your own drive, it really just removes the shortcut to that file. If you had access before, you will still have access ...
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-...
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 ...
There doesn't seem to be a way to do this, but I have found a workaround. Let's say A wants to transfer ownership of a file to B.
A shares the file with B.
B logs in, and makes a copy of the file by right-clicking on the file, and clicking "make a copy".
A or B can now delete the original file.
The new file can be renamed to be the same name as the original ...
You can add just a shortcut (from 3/2020). There is a workaround: you can use the keyboard shortcut Shift+Z and old the feature appears. You can add the shared folder to your Drive (works also in Google Sync).
More info here.
go to your Drive - https://drive.google.com/drive/my-drive
locate that PDF file
right-click it and select Share
click on Advanced
click on Change...
select one of the On - ... options
under Access: Anyone (no sign-in required) select your Can ... preference
hit the Save button
make sure that last checkbox is un-ticked
click on the Done button