If I want to import "Sheet A" from one workbook into "Sheet B" in another workbook by using =IMPORTRANGE() inside of Sheet B - when I grant it access to Sheet A is that permissions only 1 way? Meaning that If I add additional data to Sheet B will the users who have access to sheet A be able to see it? I assume not but wanted to verify.

migrated from superuser.com Nov 16 '18 at 21:00

This question came from our site for computer enthusiasts and power users.


Users only have access to specific sheets (or "workbooks") as you grant it. If you give a user access to Sheet A (aka "Spreadsheet A" or "Workbook A"), they cannot access Sheet B (aka "Spreadsheet B" or "Workbook B") in any way unless you also grant that user access to the second spreadsheet. In fact, unless you tell someone, there is no way they would know in looking at or "fiddling with" one spreadsheet that you had even imported any data out to another spreadsheet.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.