Answer the question
In order to leave comments, you need to log in
Google Spreadsheet - how to prevent individual sheets from being viewed?
I have a Google Spreadsheet with multiple sheets. How to securely prevent viewing individual sheets? Those. there is access to only 2 out of 10, for example. Already changed my mind about all the options, incl. with hiding sheets and displaying by password. But in any case, he can make a copy and work with it, removing all restrictions. If this is not possible, is it possible to do this: Make a common file with all sheets, and do IMPORTRANGE in other files? But then again the same problem - in IMPORTRANGE you need to insert a link to the table, and if there is a link, you can simply open it in the browser and make a copy of the table with all the sheets.
Answer the question
In order to leave comments, you need to log in
Found how to bypass all restrictions. IMPORTRANGE was not suitable because there was a possibility that the user would copy the link, copy the document and uncover the document as he wanted. I did this: File - Publish on the Internet. And users see their data, and you can’t get to the bottom of the parent file. Thanks to all who responded
Yes, via importrange. In this case, you do not need to make the source table public: the formula itself will request access to the source table, which will be available only to it.
If you want to not only restrict access to the sheets of the table in this way, but also hide the link itself or the entire formula in general, write to the mail, I will tell you and help you do it.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question