3

So lets say I have a Spreadsheet and I press the share button to Public (no edit except me). I have 2 sheets but only want other users to see 1 sheet.

Without having to create another document is there a way I can set it so the public can only see 1 of the sheets in this file?

2
  • Perhaps this answer is of use: webapps.stackexchange.com/q/36765/29140 May 22, 2014 at 8:11
  • You can do the workaround by protecting the respected sheet alone with the permission like view only /comment only by choosing the drop box in the titlebar of the sheet.You can hide the sheet by choosing the hide sheet icon on the same sheet so that it is hidden from other user you have shared
    – BDRSuite
    Dec 29, 2014 at 12:35

1 Answer 1

2

No, this is currently not possible. You can protect sheets (and ranges) so that other users cannot edit them, but not entirely hide them. You can create another Spreadsheet and use the ImportRange-function to import the data to the new Spreadsheet. If you do this, though, be aware that the users viewing the second document can see the unique key of your document, so if you're not careful they can import the data from your other sheet as well.
If you do it this way, put the sheet you want to share first in your Spreadsheet and name your other sheet something other users couldn't guess. If you don't give the importRange-function a sheet it automatically uses the first sheet, then if any other user wants to get data from the other sheet they have to know it's name. It is possible to find the data with a brute-force attack, so if your data is really sensitive I don't recommend this.

A second, much more secure, way is to use a script. You still have to create two Spreadsheets, one with both sheets and one empty Spreadsheet which you will never edit yourself.
Build a script that, when you edit a cell in the original sheet, pushes that value to the corresponding cell in the second sheet.
Tell me if you need help with this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.