Google Sheets - Protect or Totally Hide Data Using IMPORTRANGE

It is easy to protect certain cells or worksheets from editing. However, in this tutorial, we will review how to totally hide confidential data while allowing users to see a summarized version without the sensitive data. This prevents the data from being modified but also prevents it from being viewed.

Learn more from Prolific Oaktree:

Timestamps:
0:00 General Setup
1:37 Setup for this spreadsheet
3:34 IMPORTRANGE function
5:52 Security consideration
7:14 Next: Pivot Table Playlist

#googlesheets #IMPORTRANGE

[gbjuojm]

hello dear, how I can also allow the people who share with them the specific sheet to edit also the sheet, not only see, when the another man edit or clear any data, there is error message showing for him

[amosmurigu]

hi @Prolific Oaktree i had a question how to you synch two google sheets in such a way that if you update sheet A, it automaticaly gets updated in sheet B and aslo vice versar .

[srisri-txfd]

hi, if the end user copy and paste the importrange url in a seperate brower windows
, then he will be able to access all the tabs, whats the solutionf or this.pls advise

[rattanaknuonsinoeun]

I use import range and do the summary in other sheet, but it can not load the data from the sheet of data entry, how can you solve this?

[edmr]

When sharing publicly a spreadsheet you can create a TAB called SOURCE and HIDE it so others with public link will not know your source spreadsheet URL. this way SOURCE TAB It will not be available for reading for people with link. After that you can pull data from that tab in other tabs.

[exanimumque]

Hello.

I have a list of data. I dont want people to see the entire list, they can search for keywords and that'll bring up the lists containing the keywords. How do I hide the entire list from plain view, and only show data once keywords have been typed in?

[stephensloan]

Amos Murigu, I have been trying to find out the same thing. What I've found so far is the parent sheet can change and will show up on the child sheet but not the other way around. But what I'm really trying to find out is, we have a file with 20 plus tabs/sheets. We want to share with different vendors. Some of those vendors need to add info into the sheet. But we don't want vendors to see the tabs that don't pertain to them. How can we hide those tabs. I know we can protect them but I don't want them to have viewing access to all tabs.

[jkatqc]

Is there a way to hide the formula bar in the public sheet so users can't see the source sheet url?