![]() ![]() Because CodeCamper has rights of access to yuri's A spreadsheet, because it's public.īut CodeCamper doesn't have any right of access to yuri's private spreadsheet so called B.Īn thus, if yuri deletes the importRange function that retrieves data from a B private spreadsheet for A spreadsheet, CodeCamper will not be able to make an importrange anymore to the private data that was previously shown on A spreadsheet. If yuri's A spreadsheet has an Importrange function calling to another spreadsheet, private one, owned by yuri, called B, then CodeCamper will have access to this data thru spreadsheet A. Lets say there is another user called CodeCamper, unrelated to the previous user Yuri.ĬodeCamper has a spreadsheet and does an importrange to yuri's public spreadsheet ( A: the public one).Īs A is a public ( find and view ) spreadsheet CodeCamper will be able to reach any data present on that spreadsheet. What happens when we add a second user to this same owner problem? If there are two users it's enough to revoke access rights of the imported spredsheet to revoke the importRange access, as explained before. Within the same user there is no way to revoke this access other than deleting any of the two involved spreadsheet, so no, once you granted the importrange rights you can not revoke it for spreadsheets under the same owner. Once this access is granted any editor on the destination spreadsheet can use IMPORTRANGE to pull from any part of the source spreadsheet. If the answer is yes, the user is requested to give ImportRange access to the required spreadsheet. Has the user access to the spreadsheet is he trying to import? When you call ImportRange for first time on a spreadsheet the question raised is: This changes may take some time to propagate, so you may experience certain delay till the rights are denied, this may cause that you keep seeing the imported data for some time, but it won't last very long till the access rights are updated.Īs a tip: You can make the propagation to happen faster by modifying any cell on the original spreadsheet, once you change it, the imported ranges from the destination spreadsheet will try to get an update, as the rights were revoked, the IMPORTRANGE function will tell you that you do not have permission to access the source sheet anymore. Now you can see all the people you've given access to this spreadsheet.īy removing the given rights of access to this data you'll revoke the IMPORTRANGE access rights.On the top right of the Spreadsheet document click on Share.If you want to revoke permissions you just need to open the original spreadsheet: ![]()
0 Comments
Leave a Reply. |